[Zope] Timing SQL queries
Andrew M. Kuchling
akuchlin@mems-exchange.org
Tue, 26 Oct 1999 13:36:35 -0400 (EDT)
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?
--
A.M. Kuchling http://starship.python.net/crew/amk/
Here lies, extinguished in his prime, / a victim of modernity: / but yesterday
he hadn't time--- / and now he has eternity.
-- Piet Hein