Re: [sqlite] Long update times

2008-06-19 Thread Jay A. Kreibich
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

Re: [sqlite] Long update times

2008-06-19 Thread Jason Tudor
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

Re: [sqlite] Long update times

2008-06-19 Thread D. Richard Hipp
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

[sqlite] Long update times

2008-06-19 Thread Jason Tudor
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