On Tue, 16 Jul 2013 18:17:41 +0200 Paolo Bolzoni <paolo.bolzoni.br...@gmail.com> wrote:
> I tried the experiment again with -g3 -O0, I got less > information than expected (there are still many unknown > symbols in libsqlite3.so), but the function requiring all > this memory is sqlite3_step. Can you show us the query and/or schemas? If not: a) Does it JOIN multiple big tables (in rows and/or columns)? b) If it's joining multiple tables, is the select something like select * .....? c) Do you really need '*' or only use some columns? d) Do you use LEFT JOINS? Has the joining key an index? e) Did you normalize the database? In both cases (if you can show us the query/schema or not) what do you really want to ask to the database? (not to us but to sqlite3, perhaps the query can be reformulated) > So maybe it is one complex query? > I would like to avoid excessive swapping on the > production server, maybe I should not worry at all? -- Eduardo <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
