On 12/3/07, Adrian R. <[EMAIL PROTECTED]> wrote: > > > 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"?
Did you test out the performance using both the MERGE and TEMPTABLE algorithms for the MySQL views? Sometimes one can be vastly better than the other in terms of performance and it seems MySQL doesn't always pick the right one. So that's one idea. I get the impression, though, from both my own experience in trying out views and looking around the web for help in getting them to perform better, that the performance of MySQL views is not the best, so switching algorithms might not help. 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?;) I don't know how to go from raw sql to a QuerySet. My own custom managers start with a model's default QuerySet and modify it using the standard exclude(), etc. Can you describe your views in terms of regular Django operations on a model's QuerySet? Note there's a lot you can do with extra(). That's the first way I'd try to approach it, rather than trying to turn the results of raw sql into a QuerySet. 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
