On Wed, 21 Mar 2007, Geoffrey S. Mendelson wrote:
With 30 million records in a database, I would seriously consider a different hardware platform. Some of the perform quite well with Linux some do not.
30 million records is not a lot. But it is too much if one expects to write things like SELECT * FROM baz WHERE foo ~ 'baz' SORT BY date; . And whoever expects that to be fixed by using faster hardware needs help. And whoever expects to handle the output of that command using a 'simple PHP4 script using a Zend [tm] optimizer for speed' needs a *LOT* of help. An example of an online something with x millions of records are the Whois servers. Afaik they do not use SQL, nor Oracle, they use custom solutions running on 'bare hardware' (e.g. dbm etc). You also probably want to read up on more advanced indexing methods (like Bloom and Blooming filters and such) than what's available with ordinary off the shelf databases. Incidentally 30 million records *require* 64 bit cpu and os, so it's not an 'x86' question at all.
Peter ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
