Kasper Daniel Hansen <[EMAIL PROTECTED]> wrote: > Hi > > We are using SQLite for a fairly big (but simple) calculation, and > have some problems when creating an index on a database with > 600.000.000 rows. Specifically it has not ended even after 5 days of > running. We have done it successfully on 25% of the full data base, > and are now wondering what we can do. >
This is likely a locality of reference problem. It comes up about every two weeks on this mailing list. You can read more about it by looking at the mailing list archives. I think I know how to fix the problem. But I have not yet had an opportunity to implement the fix. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
