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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
