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
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
"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
- 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
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
- 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
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
7 matches
Mail list logo