On Tuesday, September 17, 2013 3:59:31 PM UTC-4, Michael Bayer wrote: > > there's a modern recipe at: > http://www.sqlalchemy.org/trac/wiki/UsageRecipes/Profiling > > but yeah, thats ConnectionEvents. what's the issue there, you need how > long result fetching takes ? >
thanks! yeah. Some of the more analytics oriented db calls on a certain page were taking too long ( 4s ). On Sunday afternoon , i started porting it to a Graph database, and redid a handful of postgresql tables, normalizing 3 of them into 7 [ so it reflects a 1:1 matchup of how that data is in the graph db ]. The postgres backup calls on this model were originally around 30s each ; I've got all but 2 down to 30ms or less. The last 2 seem to be stuck at 1500ms each. anyways, i'm looking at all the queries throughout the app now , and playing with indexes and rewriting the selects/joins. -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
