SQL/Python question -- slow... What is the fixed cost?

Ignacio Vazquez-Abrams ignacio at openservices.net
Thu Oct 4 12:42:13 EDT 2001


On Thu, 4 Oct 2001, Leonardo B. Lopes wrote:

> Thanks for the tip. I actually have used the explain statement. But are
> you sure about the profiler ignoring the time taken by the query? Why
> would it be excluded from the computation time? How would the profiler
> even be able to distinguish between time waiting in a function for some
> external process and time spent in the python interpreter itself? I
> checked the manual for the profiler section. It says that the profiler is
> activated by callbacks when functions are called and when they return, so
> if a function is blocked waiting for mysql, that time should be computed.

It is taking the MySQL time into account; it's just that MySQL is /REALLY/
fast for small- to medium-sized (1-3 tables, 2-7 conditions, tables indexed
appropriately) queries.

-- 
Ignacio Vazquez-Abrams  <ignacio at openservices.net>





More information about the Python-list mailing list