On Fri, Apr 24, 2009 at 10:45 AM, julianb <julian....@gmail.com> wrote:
> > Hi, > > I have used Django 1.0.2 but moved to beta, because I badly needed > some new features. I want to "report" that I found some queries to > take considerably longer, while not having changed anything in the > code at all. I talk about a rather simple query, but one which > involves some joins with tables containing > 1 million rows. On the > "old" Django version everything was running absolutely smoothly. > However, once I switch to a later Django revision, the specific page > with it's queries comes to halt. It's like someone hit the brakes. > Whithin minutes the site is not usable at all and MySQL is still busy > with the initial queries. Just switching Django back to old makes > everything run fine again. > I'm using MySQL and with the latest version the queries take seconds > and are displayed in the processlist as being prepared, sorted, sent > and so on while on the old version it was running whithin miliseconds > as I sad. > Now, I don't know where I should start looking for something going > wrong, or if any db conenction/MySQL/ORM things have been changed > lately. I appreciate any help in solving this. Something that > definitely worked should get working again with the latest Django, > too. Thanks! I'd start by using a couple of Python shells (one using 1.0.2 and one using 1.1 beta) and connection.queries to see if you can see the difference in SQL generated for whatever model queries your view is using: http://docs.djangoproject.com/en/dev/faq/models/ Karen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
