[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