Hello, I have a few models in my Django-App which are accessing MySQL-views. They return the correct result but the performance is really bad when I try to filter the results. I tried to speed up the view by query optimization but that's not good enough by half. When I execute the query to get all models which have a special key the sql-code is like "SELECT * FROM view WHERE IdColumn=foo" which takes approximately 5 seconds but if I move that condition into the sql code of the view it just takes 0.01 seconds. Has anyone an idea how to tell MySQL to "put that condition into the view query"?
Because I didn't find anything helpful for that the next idea was to use raw sql with the same conditions like above without using a view and put it into a model manager. The problem is that I don't know how to return a QuerySet from the result or how to use the filter()- function with raw sql. Is it possible without rewriting/copy and modify half of the Django sourcecode?;) -- Regards Adrian --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
