Re: [sqlite] performance trending

[Kees Nuyt]

On Mon, 28 Sep 2009 19:07:05 -0700 (PDT), oryann9
 wrote:

>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
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] performance trending

[Simon Slavin]

On 29 Sep 2009, at 3:07am, oryann9 wrote:

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

Because SQLite is just a set of library calls, and not a way to talk  
to a server, it's extremely difficult to separate out the work done in  
accessing the database from the other work your application does.   
Similarly, the amount of memory taken up for SQLite to store its own  
internal state is usually trivial compared to the amount taken by the  
language you're using for programming.  For instance, even fairly  
tight languages like Python take more memory up storing a row of data  
than SQLite does itself.

If you are interested in the amount of time taken for an individual  
operation or a set of operations, you can use the command-line tool



and use '.timer ON'.  This can be useful in testing various strategies  
for storing lots of values in one column or splitting up a value into  
components and using a compound index.

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

[sqlite] performance trending

[oryann9]

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