Ticket #161 (new enhancement)

Opened 2 years ago

Last modified 8 months ago

SQL Monitor for monitoring performance

Reported by: bob@redivi.com Assigned to: anonymous
Priority: normal Milestone: __future__
Component: SQLObject Version:
Severity: normal Keywords:
Cc:

Description

When building apps that need to scale up, it helps to know what your problem queries are. It'd be nice if you could set up a SQL Monitor that measured the time a query takes to execute.

Beyond that, you'd of course want to be able to filter out just the slow ones, color them by how slow they are, and get a traceback to where the query came from (perhaps the next time it executes).

A rather primitive version of this kind of facility is in ADOdb for PHP: http://phplens.com/lens/adodb/docs-perf.htm

Change History

09/23/06 17:59:26 changed by jorge.vargas

  • type changed from defect to enhancement.
  • component changed from Toolbox to SQLObject.
  • milestone set to __future__.

this sounds like a backend dependant project or else you will have a lot of overhead.

I suggest it to be part of debug=1 on SO.

after that then we may develop a tool to catch those in a "nice GUI"