Re: Really slow performance on webfaction

2010-09-28 Thread pjrhar...@gmail.com
Thanks for the help guys. I started trying to log things, and only then did I notice that I'd missed the obvious - one of the few queries was taking 11s! Turns out it was a pointless join from a weird use of queries (a queryset contructed one place with more filters added elsewhere in an odd order

Re: Really slow performance on webfaction

2010-09-28 Thread Bill Freeman
Are you running with the same data set both places? The biggest speed problem I ever had in deployment was because real data blew the database up with a huge join. My dummy data on the test box didn't evoke it. (Fix was to get a simple query set and loop over it so that another query could be qu

Re: Really slow performance on webfaction

2010-09-28 Thread Shawn Milochik
Do you see anything at all like this if you run your app from your development box? You can always use the Python debugger to trace for your code and look for bottlenecks. (Awesome tutorial) http://www.doughellmann.com/PyMOTW/pdb/index.html Also, put in logging and add log.debug statements in

Really slow performance on webfaction

2010-09-28 Thread Peter Harley
Hi all, I'm trying to figure out possible causes for really slow performance of my site on my production server on webfaction - it can take up to 15s to load! It only seems to be a problem on the home page of my site and it also doesn't seem to be anything like too many queries. Using the debug t