Return to BSD News archive
Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!munnari.OZ.AU!news.ecn.uoknor.edu!feed1.news.erols.com!news.maxwell.syr.edu!hub.org!news.gv.tsc.tdk.com!news.cmc.net!news-out.internetmci.com!newsfeed.internetmci.com!news.silcom.com!not-for-mail From: David Carmean <dlc@silcom.com> Newsgroups: comp.unix.bsd.freebsd.misc Subject: Re: mSQL SLOOOOW??? Date: 12 May 1997 04:30:24 GMT Organization: Silicon Beach - Business Internet Services Lines: 47 Message-ID: <5l66d0$l1m@ocean.silcom.com> References: <5krqn6$cm@ocean.silcom.com> NNTP-Posting-Host: beach.silcom.com Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-Newsreader: TIN [UNIX 1.3 unoff BETA release 970118] Xref: euryale.cc.adfa.oz.au comp.unix.bsd.freebsd.misc:40745 Thanks for the mail replies. The machine actually had 128MB; I just didn't yet know enough about FreeBSD to configure the kernel to see it. Now after the first query, the file is cached in RAM and the queries take about four *seconds* instead of four minutes. I must still have an I/O problem, I think. And should a simple 124000-line, 13MB text table *really* grow to 85MB when I import it into MSQL? David Carmean <dlc@silcom.com> wrote: : Got FreeBSD 2.1.7 running on a Pentium 166, with 64MB RAM, Micropolis : 4221-09 AV SCSI drive, Bt958 SCSI controller. : mSQL 2.0 B5 (and B6); 124000 record table, no index, ~80MB resulting : database file. A simple exact query takes nearly four minutes to : run; a little less than a minute when database is copied onto MFS : filesystem. : Should this *really* take this long to do a query on a 124000 row : table? Grepping a flat file is faster. : The machine is doing nothing else of significance, and only the one : query is running. Ktrace/kdump doesn't show any unusual looping or : anything, but then again, this is my first experience with FreeBSD, : mSQL, and ktrace/kdump all at the same time. : Any way to benchmark this? This seems unreasonably slow. : Thanks. : -- : David Carmean <dlc@avtel.net> : Avtel Communications, Santa Barbara, CA +1-805-730-7740 : Opinions herein are those of the author only, unless otherwise noted -- David Carmean <dlc@avtel.net> Avtel Communications, Santa Barbara, CA +1-805-730-7740 Opinions herein are those of the author only, unless otherwise noted