Mailing List Archive


Back to the month index Back to the list index
Bill Drury (bild@io.com)
Mon, 9 Sep 1996 16:40:43 -0500 (CDT) 

Date: Mon, 9 Sep 1996 16:40:43 -0500 (CDT)
From: Bill  Drury  <bild@io.com>
Subject: [mSQL] Large Databases
Message-Id: <Pine.BSI.3.95.960909163504.8582A-100000@pentagon.io.com>

I have a database of 186,000+ records, the total is about 50 MEG on disk
... running Linux and 1.0.16 mSQL on a P90 with 16 meg of RAM, it takes
somewhere on the order of 3 minutes (and all system resources) to do a
single match against an arbitrary field in there. Yes, the Sparc 20 w/256
meg would be great, but not every shoestring startup can afford such a
beast. The code seems to do a sequential match rather than any sort of
more advanced searching tricks, so every record you add to a table seems
to increase the search time ... has anyone hacked around to try to get it
to store its databases in more search-friendly forms?

(Not counting the phantom mSQL 2.0 release, which I don't actually believe
we'll ever see. :)

bild

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!