logging server execution time

[John Zandbergen]

Hi all,

My program is doing a lot of queries. In order to get a better overview of the server-load it generates, I would like to log the server-time per query executed. This would help me determine if we should skip some queries (and/or build redundant data into the database).

Is there a field in some data structure that I can use to get the time it took to execute the mysql_query() or mysql_store_result() ?

Thanks,
John