Why do you need to create a new table each time? Its easier to create a relational database. This means create one main table that might (for example) have a 'tableID' field, which points to just one other table. This means you only need two tables. Not 20,000+ Just an idea. Depends on what you're trying to achieve.
On Mon, Jan 28, 2019 at 4:18 PM <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. > > How can I speed up? > > Thanks. > > Davide > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users