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