*BSD News Article 95008


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