Thank you, but the question is not how I can insert records per second.
it is for a web application (multiuser, WAL mode). Many threads (connections via internet) can access the database. If each thread writing (a transaction that contains one or more INSERT/UPDATE) takes an average of 10 ticks, and each thread reading (a transaction that contains one or more SELECT) takes an average of 10 ticks, I would like to know how many thread SQLite can handle in one second or one minute, very roughly, with WAL. Le 14 nov. 2011 à 15:42, Petite Abeille a écrit : > > On Nov 14, 2011, at 3:33 PM, Paxdo Presse wrote: > >> If my write transactions consume an average of 10 ticks (1 ticks = 60th of a >> second), it means that I can get very approximately 6 write operations per >> second? (with a recent computer powerful enough). >> At the same time, how many read operations (an average of 10 ticks) do you >> think SQLITE can do? > > 15:56:06 [ETL.Load] Inserting into movie > 15:56:41 [ETL.Load] Inserted 1846820 rows into movie > > If you can insert 1,846,820 rows in 35 seconds, or around 57,766 rows per > second, what's the age of the DBA? > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
