[sqlite] querys for analysis for performace measures

HiI 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? Thank you

Re: [sqlite] sqlite-users Digest, Vol 21, Issue 122

>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. Set up a suite of benchmark queries and use the perfor

[sqlite] performance trending

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. thank you!