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. Thanks for your help. -Tudor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
