Hi guys --
Just svn'ed up the latest source and I noticed a return to the
extremely long time for reflection, on the order of around 63 seconds
for twenty odd tables, with a fair number of foreign keys and
such. The backend is a PostgreSQL 8.1 server running on my WinXP workstation.
Looking at CPU utilization, the postgresql process is maxed out with
the python process kicking at one or so percent.
I took a look at the echo=1 output and it all looks fairly
straightforward -- no duplicate queries for information, no obvious
loops or other operations. I've tried the obvious trick (rebooting)
and this still occurs.
I dug a bit more on the log file, and it shows about three seconds
per query, which is obviously excessive. After several runs,
however, the delay drops down to a more reasonable few ms, but those
in #postgresql attribute this to caching more then any change in behavior.
In further analysis, I don't think this is a SA problem at all, since
the query takes three seconds (prior to cache pickup) from within
psql, completely outside of SA's framework.
Any suggestions? Anyone seeing similar behavior?
--G
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
