Thread

Searching LOADS of records | ANSWER

Dennis Fleurbaaij <dennis@core-lan.nl> — 2001-04-14T13:23:24Z

Okay this is going to be off topic as this an answer rather than a
question :)

I've build a database which has LOADS of tupels (records) containing the
filenames
and other info about files in a network. This db is over 5 million
records in size and
is heavily loaded.

You can imagine that this was dead-slow when i did a select (about 10-40
seconds response time). After my first post here I've investigated the
FTI of Full Text Indexing. This is a contrib
of the database. This brought down search-times back to < 0.5 seconds :)

So if anybody has the same problems as I had with too slow queries and
too large databases
on slow machines (my laptop isn't exactly SCSI3 raid0 15Krpm :) try that
avenue this
has helped me greatly and I encourage everybody to try it.

Ow a shoutout to Justin Clift for pointing me in the right direction.

Hope this helps,
Dennis Fleurbaaij
dennis@core-lan.nl