#4 Optimize your queries with log system

[Frédéric RUAUDEL]

If you set the logging level to level 3, sqlb will log
every SQL query it manages with some useful information
to make optimisation.

Example :

Tue Jul 3 10:35:06 2001 sqlbquery[12049]: [SQL Query]:
00000001 [10ms][70] -select id from
Etats-

Here is the format :

Date | sqlbquery's PID | number of query manage by this
sqlbquery | time to execute the query | size of the
resultset | the query executed

With this you can see which queries slow down your
program and the relation with the size of the resultset.