Re: [sqlite] SQLite slow when lots of tables
thanks a lot for fast answers. Now I'll try to modify my DB structure to use one table. Thanks to all. Bye. > > Il 29 gennaio 2019 alle 12.29 Simon Slavin ha > scritto: > > On 29 Jan 2019, at 11:00am, mzz...@libero.it wrote: > > > > > > what happens if I put all data in a single table and this table > > become very huge (for example millions of rows)? > > > > Will I have same performace problems? > > > > > > I used to use a 43 Gigabyte SQLite database of whto useich 42 Gigabytes > was taken up with a single table. Worked fine. And fast. > > That was several versions of SQLite ago. SQLite is faster now. > > Simon. > > ___ > 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
Re: [sqlite] SQLite slow when lots of tables
Dear all, what happens if I put all data in a single table and this table become very huge (for example millions of rows)? Will I have same performace problems? Thanks. Regards. > > Il 28 gennaio 2019 alle 17.28 Simon Slavin ha > scritto: > > On 28 Jan 2019, at 4:17pm, mzz...@libero.it wrote: > > > > > > when the number of the tables become huge (about 15000/2 > > 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? > > > > > > Put all the data in the same table. > > At the moment, you pick a new table name each time you write another set > of data to the database. Instead of that, create just one big table, and add > an extra column to the columns which already exist called "dataset". In that > you put the string you previously used as the table name. > > SQL is not designed to have a variable number of tables in a database. > All the optimization is done assuming that you will have a low number of > tables, and rarely create or drop tables. > > Simon. > > ___ > 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
[sqlite] SQLite slow when lots of tables
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/2 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