the profiling will show you if there's some network/server overhead from fetching rows, if you can see where psycopg2 is actually doing that.
On Sep 26, 2013, at 2:44 AM, Jonathan Vanasco <[email protected]> wrote: > yeah. painfully slow. > > i can't seem to recreate this on a test script. it happens every so often in > a pyramid app , but I can't recreate it on a bootstrapped (command line) > pyramid instance. my test suite shows this happening instantly. > > this has been troubling me for over a week since i noticed ( hence all my > profiling concerns and query rewriting ) > > i've got the raw queries down to a matter of milliseconds. sqlalchemy seems > to do the roundtrip with no overhead. every so often, the web-enabled > version just hangs for a few seconds -- right after data comes in from > Postgres [ i've been watching the logs like an eagle ]. > > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/groups/opt_out.
signature.asc
Description: Message signed with OpenPGP using GPGMail
