Re: [sqlite] How do I speed up CREATE INDEX ?

2006-12-03 Thread Michael Sizaki
Re: [sqlite] How do I speed up CREATE INDEX ? "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

Re: [sqlite] How do I speed up CREATE INDEX ?

2006-12-03 Thread Mohd Radzi Ibrahim
TED]> To: <sqlite-users@sqlite.org> Sent: Sunday, December 03, 2006 8:21 PM Subject: Re: [sqlite] How do I speed up CREATE INDEX ? "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

Re: [sqlite] How do I speed up CREATE INDEX ?

2006-12-03 Thread drh
"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 ? > The reason index

Re: [sqlite] How do I speed up CREATE INDEX ?

2006-12-02 Thread Mohd Radzi Ibrahim
- Original Message - From: "P Kishor" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, December 03, 2006 10:42 AM Subject: Re: [sqlite] How do I speed up CREATE INDEX ? On 12/2/06, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote: - Origi

Re: [sqlite] How do I speed up CREATE INDEX ?

2006-12-02 Thread P Kishor
On 12/2/06, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote: - 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

Re: [sqlite] How do I speed up CREATE INDEX ?

2006-12-02 Thread Mohd Radzi Ibrahim
- 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

Re: [sqlite] How do I speed up CREATE INDEX ?

2006-12-02 Thread Jay Sprenkle
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