Re: fastest database
From: Jan.Hidders <hidders_at_hcoss.uia.ac.be>
Date: 27 Aug 2002 11:07:09 +0200
Message-ID: <3d6b413d$1_at_news.uia.ac.be>
Date: 27 Aug 2002 11:07:09 +0200
Message-ID: <3d6b413d$1_at_news.uia.ac.be>
In article <3d6a7705$1_at_wobble>, Michael <mike_at_pvbb.net> wrote:
>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.
MySQL. Very fast. The stable version has reasonable good fulltext indexing, the "almost stable" MySQL4.0 even better. If you want to see it fly, visit slashdot.org.
- Jan Hidders