The "sqlite3_analyzer" program reads an SQLite database file and prints out a text summary of the sizes of the various tables and indices in that database file. The source code to sqlite3_analyzer is in the public SQLite source tree; you can type "make sqlite3_analyzer" or "make sqlite3_analyzer.exe" to build it yourself. Or you can download precompiled binaries for popular platforms from the SQLite download page: http://www.sqlite.org/download.html
In order to better understand how SQLite is being used, and to better tune future versions of SQLite for its more common use cases, I'm asking you to run the sqlite3_analyzer program on some of your database files and to send me the output via private email. Any sqlite3_analyzer output files you send will remain in this office. Nothing will posted or revealed publicly. Note also that the output of sqlite3_analyzer does not contain any database content so sending such output to me does not reveal any confidential information. However, the output of sqlite3_analyzer does reveal some information about the database schema. Hopefully, the schemas of your databases are not so sensitive that you cannot share them with us in confidence. All sqlite3_analyzer output is of interest, but an analysis of larger database files is of particular interest. Note that we already have abundant information on common SQLite database files such as Fossil repositories, Firefox "places" files, Android contact lists, and so forth, so do not send more of them. We are looking for other uses of SQLite. We want to verify that the workload patterns we see in these well-known SQLite databases is typical. So if you are using SQLite in an unusual way, we especially would like to peek at your sqlite3_analyzer output. If you want to also include a few words about how each analyzed database is used, that might also be helpful to us, but is not essential. Thanks for your help. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
