On 16 Jul 2013, at 5:17pm, Paolo Bolzoni <paolo.bolzoni.br...@gmail.com> wrote:
> the function requiring all > this memory is sqlite3_step. > > So maybe it is one complex query? Possibly a query for which no good index exists, so SQLite decides to make up its own temporary index. If you consider this amount of memory usage to be excessive (which I am not saying is or is not the case) drop your indexes and make up better ones. Remember that the purpose of an index is to be ideal for the clauses of a SELECT or UPDATE statement. There is no point in indexing a column just because that column gets used a lot. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
