On Wed, Dec 5, 2012 at 10:56 AM, Richard Hipp <d...@sqlite.org> wrote: >> It is not an indexing issue. For one of the UPDATE SQLs, it is >> updating a table with only 1 record in it. And this takes > 350ms... >> > > Can you provide specifics: The schema and the UPDATE statement?
Schema and SQL are below: CREATE TABLE `k_user` ( `user_id` integer primary key autoincrement, `user_name` varchar(50) default NULL, `created_at` datetime default NULL, `user_group_id` bigint(20) default NULL, `x` double default NULL, `y` double default NULL, `heading` double default NULL, `altitude` double default NULL, `speed` double default NULL, `state_id` bigint(20) default NULL, `status` varchar(15) default NULL, `last_updated_at` datetime default NULL ); update k_user set x = ? , y = ? , heading = ? , last_updated_at = ? where user_id=? It cannot get simpler than this. For the inserts, it is just as simple. A table with 15 columns, and a straight insert. Regards Keith _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
