Thanks for the response Pavel. The order that the events were getting
logged wasn't accurate enough so I increased the timing precision for my
logging. I didn't leave anything out, but some commands were logged
slightly out of order.
Thread1 is doing reads and writes for a while, with
I am running into a database is locked error and I don't quite
understand what is going on. If someone could explain what is happening,
I'd appreciate it. (I am using sqlite version 3.6.17 on Windows XP.)
A busy handler callback has been set up with sqlite3_busy_handler(). In
addition to some
Do not be tempted by the incremental vacuum feature. Incremental
vacuum will reduce the database size as content is deleted, but it
will not reduce fragmentation. In fact, incremental vacuum will
likely increase fragmentation. Incremental vacuum is just a variation
on auto_vacuum.
I am trying to use the Sum function on a column in a table with ~450K
rows in it.
Select sum(Col4) from Table1
Where Table1 looks like this:
Create TABLE Table1 (
Col1 INTEGER NOT NULL,
Col2 INTEGER NOT NULL,
Col3 INTEGER NOT NULL,
Col4 BIGINT NOT NULL,
Trainor, Chris chris.trai...@ironmountain.com
wrote:
I am trying to use the Sum function on a column in a table with ~450K
rows in it.
Select sum(Col4) from Table1
It takes over 2 minutes to execute when using the original table. I
created an exact copy of the table with the same indices
...@netscape.net wrote:
Trainor, Chris wrote:
After running vacuum, sum is fast on the original table. However,
running vacuum took a long time, so I'm not sure if that is a feasible
solution. Is there any way to prevent fragmentation in the first place?
If not for the whole database
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Machin
Sent: Tuesday, March 03, 2009 7:53 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Slow performance with Sum function
On 4/03/2009 5:52 AM, Trainor