On Thu, Jun 19, 2008 at 09:20:24AM -0700, Jason Tudor scratched on the wall:
> The blob sizes are about 24KB.
You do understand the command "UPDATE Objects SET Lock = 1" will
update all 12,243 rows, right? And that requires the whole table to
be sucked in off disk, modified, and written
The blob sizes are about 24KB.
I downloaded the sqlite3_analyzer, is there any documentation on this? It's
just an executable and when I dbl click I get a console window that
disappears.
Also, the time I gave was wrong, it was closer to 55 seconds. I set the
synchronous flag to 0 (NONE) and
On Jun 19, 2008, at 9:17 AM, Jason Tudor wrote:
> Hello Everyone,
>
> I was hoping that someone could explain why my updates are taking so
> long.
> My schema is as follows:
>
> CREATE TABLE Objects (ObjectId INTEGER PRIMARY KEY, Name TEXT, Type
> INTEGER,
> Lock INTEGER, Data BLOB 3DDataId
Hello Everyone,
I was hoping that someone could explain why my updates are taking so long.
My schema is as follows:
CREATE TABLE Objects (ObjectId INTEGER PRIMARY KEY, Name TEXT, Type INTEGER,
Lock INTEGER, Data BLOB 3DDataId INTEGER DEFAULT NULL)
My table has 12,243 rows.
when I execute the
4 matches
Mail list logo