On Mar 30, 9:36 am, Dipo Elegbede <delegb...@dudupay.com> wrote: > Hi all, > > I have a django application that uses mysql database. > > Everything works just fine except that I noticed some queries do spend a lot > of time to load. > > I have about 15,000 checklists the system would have to browse through to > render my dashboard, which indicates which checklists is totally complete or > partial and all. > > I would love to know if there is a way to make these queries work faster. > > I have tried caching but that would be useful for as long no new data is > hitting the database which is most unlikely, it also disable filters which > are key part of the application. > > Is there a way to optimise mysql queries? > > kindly help. > > Documentations and explanations would be most appreciated. >
Have you looked at the queries to see what they are? Do they make sense? Are you using the django debug toolbar? Can you use select_related()? Have you run "explain" on the queries? Have you seen this: http://docs.djangoproject.com/en/1.3/topics/db/optimization/ -- 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.