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