On 29 Sep 2009, at 5:11pm, oryann9 wrote:

> I did do this, set-up a cron job using vmstat, free and top.

Great tools.  Don't forget that 'top' is a way into the information  
'ps' shows.  You might find that 'ps' shows you more useful  
information.  Or you might not.

> 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?

I think he just means you should make up a set of statements that  
resemble the statements you intend to use SQLite for.  SQLite includes  
a large test suite which might make an interesting benchmark, but it  
won't resemble /your/ use of it.  For example, some users do a small  
number of SELECT commands with complicated 'WHERE' clauses on  
extremely large databases, whereas other users do a huge number of  
SELECT commands with no 'WHERE' clauses on smaller databases.   
Improved performance on one test does not mean improved performance on  
the other.

So if you're testing SQLite for your purposes, you might want to make  
up data and usage patterns that resemble what you're going to want it  
for yourself.  That will give you a better idea how it will perform  
for you than some standardised test suite.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to