I am experiencing considerable performance problems with ORM requests, too. In django 1.2.3.
And I found two slow procedures: first is queryset cloning (sql.Query objects deepcopying is actually slow) and second - sql generation (especially, generating list of fields). Both could be a result of adding new features that made sql.Query objects very complex. I opened a topic about expensive cloning on django-developers: http://groups.google.com/group/django-developers/browse_thread/thread/5943bc1bab0711b0/95ab0714ef746469?lnk=gst&q=queryset+cloning#95ab0714ef746469 and found some people with same problem. I also use a monkey patch to avoid this problem by making querysets mutating, not cloning: https://gist.github.com/872145 -- 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.