Hi Andrew! A. M. Kuchling wrote:
Is there any support for timing SQL queries made by SQLMethods? For optimizing a site, it's nice to turn on a logging mode, exercise the site a bit, and then look at a log of every query and the time it took; this lets you notice redundant queries (means you need some caching) or unusually slow queries (means you need an index or a table rethink). Any suggestions on how I should implement this, if it's not already supported? I just added Mr. Creosote to my DA to log all of the queries via UDP to a loghost, with timestamps - this makes it easy to view the queries as they happen even on another machine, you can also take a log if you want. Crude, but it's not bad. Mr. Creosote is in the pcgi/ directory of your Zope installation...
--Brian