Return to BSD News archive
Path: euryale.cc.adfa.oz.au!como.dpie.gov.au!news.gan.net.au!act.news.telstra.net!vic.news.telstra.net!sleipnir.iaccess.com.au!news.unimelb.edu.au!munnari.OZ.AU!news.ecn.uoknor.edu!feed1.news.erols.com!news.maxwell.syr.edu!newsfeed.internetmci.com!news.silcom.com!not-for-mail From: David Carmean <dlc@silcom.com> Newsgroups: comp.unix.bsd.freebsd.misc Subject: mSQL SLOOOOW??? Date: 8 May 1997 06:09:42 GMT Organization: Silicon Beach - Business Internet Services Lines: 25 Message-ID: <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:40576 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