I don't care about hardware... i will do cluster... but which DB motor do think will be good for work with great velocity in select (sqlite, postgresql or mysql). ah.. i almost forgot... i will do a great number of select...
On 7/12/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
32 bits, the size of the key, only holds numbers up to 2 or 4 billion. You said you have 8 billion rows. You need a 64 bit version or to split up the data into many tables. On 7/12/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > So Jay... Do you think that i have to use a PC of 64 bits, or 32bits pc with > clustering? > > > On 7/12/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > > > > Hello to everybody! > > > > > > I want to ask to the people something... If i have a table with about > > > 8.000.000.000 registers, and i have to do a select in a numeric row that > > > will have index. what db do you recommend to me for use? > > > > If you design the database correctly it should work, but I believe > > that large a total number of records will not be addressable on > > a personal computer. I think the 32 bit version is limited to 2^32 > > records. > > > > -- -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com