Whiich DBMS for very large database?

nakkaya · 03-16-2003, 02:17 PM

i am working on a search engine system which will have a very very big database i looked at some benchmarks mysql was better on general i want to have your ideas in real world what happens.

Conditions on server

very very large tables
database has 8 tables
crawling and searching takes place in same database diffrent tables

markus1982 · 03-16-2003, 02:28 PM

what do you consider large ?
mysql v4 is nice for something pretty large ...

nakkaya · 03-16-2003, 02:33 PM

over a 100 GB

Tinkster · 03-16-2003, 05:16 PM

Of course it has to be postgresql ;)
Limitations

MySQL has more users than PostgreSQL...
Windows has more users than Linux ... :}

/me runs & hides ...

Cheers,
Tink

awdoyle · 03-16-2003, 07:33 PM

Here's a link you might find insightful:
http://www.eweek.com/article2/0,3959,293,00.asp
Andrew

Tinkster · 03-16-2003, 10:38 PM

And if you are interested in more than the
performance of the respective JDBC drivers
look at this one ;)

Cheers,
Tink