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

Reply via email to