On 2/2/15, Jan Slodicka <j...@resco.net> wrote: > I know the reports about huge performance increase achieved within the last > year. (Compliments for that.) However, those numbers ignore processor > architecture and I/O. My question is a different one. > > What speed difference do you perceive in real-world applications? > > I know that there can't be any answer valid for everybody and for every > situation... > > Some of my results (I compared v3.7.15.2 vs v3.8.8.1, W7, 2.4 GHz i5, RAM > 4G):
>From the description, your tests sound like you are pushing a bunch of separate SQL statements into SQLite. In other words, the compute time is likely dominated by the time need to parse the SQL and prepare plans. Have you rerun the tests using prepared statements, where you do a limited number of sqlite3_prepare_v2() calls and then reuse each prepared statement multiple times with different bound parameters? That's the kind of work-load we have been striving to optimize, since we figure anybody who is interested in performance is already making heavy use of prepared statements. > > TestA > Stress tests that executed a few thousands random SQL commands (small > tables, small commands, transactions were used to group write operations): > The differences were within statistical fluctuations > > TestB (used SQLite shell) > I dumped real production database and modified the dump file by adding a > commit after each table. Then I measured the time needed to re-create the > database from the dump file. > v3.8 was faster by some 10-15% (WAL mode) > > TestC > Same test as above, but this time one table column was filled with large > strings. (emails) > There was no speed difference between v3.8 and v3.7. > > What about your experience? Do you perceive better performance due to the > last SQLite updates? > > > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/Performance-increase-between-3-7-and-3-8-tp80355.html > Sent from the SQLite mailing list archive at Nabble.com. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
