> 9,223,372,036,854,775,807 / (1,000,000 * 60seconds * 60minutes * 24hours * > 365days) = 292471 years > > On 8/30/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> >> The maximum rowid is 9223372036854775807. You're going to take >> a long time to reach that value if you start with 1. >> >> Do the math: If you do 1 million inserts per second, 24 hours >> per day, 365 days per year, how many centuries does it take you >> to run out of rowids? >> >
We only need two bytes to store year numbers Chuck. We only need a 32bit unsigned integer to store seconds since the Epoc. We only need.... Eventually computers will mature to a point where a data intensive application can store at a rate much faster than a million inserts per second using sqlite. ;-) ( I hope ) D. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
