-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 06/10/2011 12:12 AM, Cecil Westerhof wrote: > I like to make speed comparisons for sqlite.
Comparing SQLite to other databases? Different versions of SQLite? Different configurations of the same version of SQLite? The SQLite source does include a TCL script that generates SQL statements to run for the purpose of speed testing. I reimplemented that in Python and also added a scaling factor (controls how many statements are generated for each portion), allows for Unicode characters and lets you increase the size of generated fields. See the doc at: http://apidoc.apsw.googlecode.com/hg/benchmarking.html#speedtest You can use the script to generate a text file containing SQL. python speedtest.py --scale 10 --dump-sql speed.sql To give an idea of the various things it does: - - inserts on an unindexed table - - inserts on an indexed table - - selects (unindexed requiring full table scan) - - selects using like (unindexed) - - create indices - - selects (indexed) - - selects (against rowid) - - selects (integer indexed) - - selects (string indexed) - - vacuum - - update of multiple records (indexed) - - update of single records (indexed) - - update (every row in table) - - delete all content from a table - - copy one table to another - - delete row at a time from table - - random ordered selects - - random deletes - - select count(*) These aren't particularly representative of real world applications but they do exercise the core insert/delete/select engine. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk3yQ1YACgkQmOOfHg372QTWFQCeIlXDwviKohLZmdekHWnT4Xai oYsAoM7HxNGXUGrUBqRFwghkphA4yH0e =b4Bf -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
