On 12/2/06, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote:
Hi, I was loading a file to sqlite (3.3.8), and it took 4 mins to load 6 million rows (with no index). But then when I run CREATE INDEX it took me 40 mins to do that. What could I do to speed up the indexing process ?
Details of the schema would help. Assuming you didn't create more index than you need, a faster computer is the answer. It only has to be done once so why is that a problem? -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------