----- Original Message -----
From: "Jay Sprenkle" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday, December 03, 2006 9:12 AM
Subject: Re: [sqlite] How do I speed up CREATE INDEX ?
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?
Because I'm going to do it 24 times. I have 24 monthly files each of which
about the same size. A faster computer is not an answer at this time.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
