On 30 Oct 2009, at 1:12am, oryann9 wrote: > Other than setting up typical cron jobs such as iostat, vmstat and > the like, will you provide me with a query(s) to test DB performance > time it takes to return data such as table joins and or any other > relevant system tables?
The command-line tool which is part of the SQLite download (and probably pre-installed if SQLite is pre-installed) has a command which can be used to time individual commands. Take a look at '.timer' in <http://www.sqlite.org/sqlite.html> since you're mentioning cron, iostat, etc. you're using Unix, so you might like to know that Unix has its own command to time individual commands: 'time'. Type 'man time' on your computer for details of your particular version, but the basic idea is time command So you can write a utility in your favourite language that just runs one or two SQLite commands and test not only what the SQLite function does, but the stuff you'll have to put around it in your language to prepare the parameters and extract the values that are returned into variables. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
