I second the Daniel Roseman presentation, check out his blog as well – he has a few posts about optimizing querysets.
Get debug-toolbar on there and see what's actually causing it. Bad template code is the most common thing I've found, executing the same query 1,000+ times in a loop when once would suffice. If the number of queries being run is low but they're taking ages, then ‘EXPLAIN’ the queries and see how they can be improved. 200,000 records is really not a lot. Matt Stevens | www.dirtymonkey.co.uk On 23 February 2012 11:21, kalyani ram <arch.kalu3...@gmail.com> wrote: > > Hey ppl! > > I there anybody who can help me on a problem with a slow page process > with mysql as a backend having about 2lakh records ?? > > Thanks in advance. > > Regards, > kalyani > > -- > 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. > -- 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.
