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.
I never needed this so I'm not fully sure, but isn't "INTEGER PRIMARY KEY" on sqlite v3 (it was 32 bits on sqlite v2) a 64 bits number (if needs to be, as it's "compressed" on store) ? If it is, depending on the usage, maybe sqlite is just the thing (instead of mysql or postgres), but when things get big only test cases will tell. Regards, ~Nuno Lucas