Re: fastest database

"Michael" <mike_at_pvbb.net> wrote in message news:3d6a7705$1_at_wobble...
> I have a situation where I have 40 million records that need to be
> searchable on the web. They need to be fulltext indexed for searching and
> they get about 500,000 to 1 million hits a day. Can anyone recommend what
> the fastest search database there is on the market? The current
> implementation is 40 million rows in a 55 columnn wide table with 21
indexes
> for searching multiple columns running on some heavy iron. OS is not a
> concern but I do prefer Unix.

Well, we have a product that can do _easily_ what you describe. We provide a full-text indexing and searching toolkit / library called Onix. It has very
fast indexing times and its search times are one of the fastest in the industry.

You can find product information at: http://www.lextek.com/onix/

The interface is a standard "C" style API. It can run on a wide range of platforms and compilers. (We currently have ports for Solaris, Windows, MaxOSX/OS9, Linux, BeOS, and will have HPUX shortly.)

40 million rows is easy for Onix to handle -- childsplay. Onix will also _easily_ handle the number of hits you seem to be getting even with highly complex queries.

I hope this helps. If I may be of any further assistance, please feel free to
contact me.

Thanks,

-Art

The other system you might want to take a look at if you want to take a look at one of our competitors is Thunderstone at: http://www.thunderstone.com/ Received on Thu Aug 29 2002 - 05:47:09 CEST