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 the time decreased to 30 seconds. Problem was that the synch flag did not stick. When I reopened the database, the flag was set to 2 (FULL) Thanks again for the help On Thu, Jun 19, 2008 at 7:21 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > 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 INTEGER DEFAULT NULL) > > > > My table has 12,243 rows. > > > > when I execute the following: "UPDATE Objects SET Lock = 1" > > > > I wait for about 20 seconds. I would think that the update should > > be much > > faster. > > I tried wrapping the statement with a transaction, but no luck. > > > I routinely do such operations in milliseconds. Dunno what you are > doing wrong. What hardware are you running on? How big are the BLOBs > in your table. Can you post the output from running the > sqlite3_analyzer utility (available from > http://www.sqlite.org/download.html) > on your database file so that we have a better idea of what kind of > data we are dealing with? > > D. Richard Hipp > [EMAIL PROTECTED] > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users