*BSD News Article 95151


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