[sqlite] How do I speed up CREATE INDEX ?

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 ? Thanks. Radzi.

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

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

- Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: 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

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

On 12/2/06, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote: - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: 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

[sqlite] database permanently locked

My database is permanently locked, and I've spent two fruitless days trying to unlock it. The problem: $ sqlite trac.db SQLite version 3.3.6 Enter ".help" for instructions sqlite> .databases Error: database is locked I believe this was caused by something bad happening in Trac 0.9.6. More than

Re: [sqlite] database permanently locked

Max Barry uttered: My database is permanently locked, and I've spent two fruitless days trying to unlock it. You haven't said what sort of box this is. I guess a generic Unix. If Linux, you'll probably have fuser installed. Run fuser against the database file, and it'll tell you the PID

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

- Original Message - From: "P Kishor" <[EMAIL PROTECTED]> To: 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: - Original Message - Because

[sqlite] REPLACE INTO Help Once Again

First off I want to thanks everybody that help me learn the greatness of REPLACE INTO I have crafted some very complex statements that ended saving mass amounts of time programming and much more efficient. Onto the new problem. I am attempting to INSERT OR REPLACE rows into an AccountState like