Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: fastest database

Re: fastest database

From: Jan.Hidders <hidders_at_hcoss.uia.ac.be>
Date: 27 Aug 2002 11:07:09 +0200
Message-ID: <3d6b413d$1@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.

Received on Tue Aug 27 2002 - 04:07:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US