On 1/28/19, mzz...@libero.it <mzz...@libero.it> wrote: > Dear, > > I developed an application that need to create 1 table with thousand of rows > every time when a certain event occours. > > This works in a good way, but when the number of the tables become huge > (about 15000/20000 tables) the first DataBase reading query, after Database > open, is very slow (about 4sec.) while next reading operations are faster.
When the database first opens, SQLite has to load the schema for the database (how else is it suppose to know the structure of the database?) which in your case involves reading and parsing 20,000 CREATE TABLE statements. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
