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
