On Tue, Nov 3, 2009 at 1:17 AM, Low Kian Seong <django....@gmail.com> wrote: > There is a query page where the start_date and end_date is being sent. > Then the do_defender_advanced will process it and generate an Excel > using the template.
For each object you are displaying the values of four foreign keys. Each time you access one of those foreign keys, you're doing another database query; with 3,000 objects and four foreign keys per object, you'll be doing 12,000 database queries, which is almost certainly why it's slow. I suggest you read up on the select_related() method, which can condense those 12,000 database queries into only one database query. -- "Bureaucrat Conrad, you are technically correct -- the best kind of correct." --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
