On 29 Sep 2009, at 3:07am, oryann9 wrote: > Is there a method, set of tools to gather and show either > graphically or non-graphically the performance of SQLite3 databases? > I am trying to determine the current memory, disk IO and cpu load > all DB transactions place on our server.
Because SQLite is just a set of library calls, and not a way to talk to a server, it's extremely difficult to separate out the work done in accessing the database from the other work your application does. Similarly, the amount of memory taken up for SQLite to store its own internal state is usually trivial compared to the amount taken by the language you're using for programming. For instance, even fairly tight languages like Python take more memory up storing a row of data than SQLite does itself. If you are interested in the amount of time taken for an individual operation or a set of operations, you can use the command-line tool <http://www.sqlite.org/sqlite.html> and use '.timer ON'. This can be useful in testing various strategies for storing lots of values in one column or splitting up a value into components and using a compound index. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
