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 <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
