On Fri, Jan 13, 2012 at 5:13 PM, Max Vlasov <max.vla...@gmail.com> wrote:
> John, > I read your previous post and unfortunately, your conversation with Richard > didn't reveal much details. I worked with scenario similar tou yours > (Delphi + statically linked sqlite) for several years and during this > period an advanced admin/console form was developed that allows dynamical > loading of different versions of sqlite, reporting vfs bandwidth, times and > even the number of memory requests. So consider sharing more information > about your db and queries here or contact me directly if you wish, I hope I > can help at least a little. > > As a quick guess I remember that fts was one of the places that allocated > heavily with some queries, but I can't recall right now. > > There are 88 unique queries run against the database. They are mostly automatically created from a class structure. However, without dumping the entire database in front of you, the following query should provide a good, isolated example: 5,008 calls to UPDATE RESPONSES SET RESPONSE_NAME = :RESPONSE_NAME, prelisted_value = :prelisted_value WHERE RESPONSE_OID = :RESPONSE_OID 3.6.17: 382 ms 3.7.9: 5,924 ms There are 80,021 rows in RESPONSES. The CREATE statement for RESPONSES reads: CREATE TABLE responses ( response_oid integer primary key autoincrement, response_name varchar, definition_parent integer, instance_parent integer, prelisted_value varchar, override_behavior_oid integer, soft_deleted_char varchar default 'F' ); CREATE INDEX response_definition_parent_idx on responses (definition_parent); CREATE UNIQUE INDEX response_instance_parent_idx on responses (instance_parent, definition_parent); CREATE UNIQUE INDEX response_instance_parent_idx2 on responses (response_name, instance_parent, definition_parent); _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
