[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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 performance tools of your operating system, vmstat, iostat, etc.. You can also try sar, or if you are rich, TeamQuest. -- ( Kees Nuyt ) I did do this, set-up a cron job using vmstat, free and top. I do not know how to set-up a 'suite of benchmark queries'. Will you provide me with yours or help me with the queries? thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
