On 6 Aug 2013, at 3:12pm, Bo Peng <ben....@gmail.com> wrote: > The problems we have only happens with large databases and it is > difficult to create test cases to reproduce them.
SQLite is not optimised for databases which contain a very large number of tables (hundreds). It has to scan the long list of tables quite a lot. This will lead to low speeds. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users