I have a view that does not evaluate a queryset, it just adds filters and order_by and then passes it to Paginator (set to 50 per page) and the result is passed to the template. The following SQL is generated (with some fields omitted for clarity). I'm using Django 1.0.2 and MySQL 5.1.
SELECT `lister_importedsighting`.`id`, `lister_importedsighting`.`user_id`, `lister_importedsighting`.`date_added`, `lister_importedsighting`.`active`, `lister_importedsighting`.`tax_order` FROM `lister_importedsighting` WHERE (`lister_importedsighting`.`user_id` = 1 AND `lister_importedsighting`.`birdlist_area` = ABA ) ORDER BY `lister_importedsighting`.`species_name` ASC LIMIT 50 SELECT `lister_importedsighting`.`id`, `lister_importedsighting`.`user_id`, `lister_importedsighting`.`date_added`, `lister_importedsighting`.`active`, `lister_importedsighting`.`tax_order` FROM `lister_importedsighting` WHERE (`lister_importedsighting`.`user_id` = 1 AND `lister_importedsighting`.`birdlist_area` = ABA ) LIMIT 21 SELECT `lister_importedsighting`.`id`, `lister_importedsighting`.`user_id`, `lister_importedsighting`.`date_added`, `lister_importedsighting`.`active`, `lister_importedsighting`.`tax_order` FROM `lister_importedsighting` WHERE (`lister_importedsighting`.`user_id` = 1 AND `lister_importedsighting`.`birdlist_area` = ABA ) ORDER BY `lister_importedsighting`.`species_name` ASC LIMIT 21 SELECT `lister_importedsighting`.`id`, `lister_importedsighting`.`user_id`, `lister_importedsighting`.`date_added`, `lister_importedsighting`.`active`, `lister_importedsighting`.`tax_order` FROM `lister_importedsighting` WHERE (`lister_importedsighting`.`user_id` = 1 AND `lister_importedsighting`.`birdlist_area` = ABA ) ORDER BY `lister_importedsighting`.`species_name` ASC LIMIT 21 My question is why are the last 3 queries present, and where did limit 21 come from, a number not present in my view at all? It matters because in some cases my SQL queries are much more expensive than this, and they run for every page if Paginated. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
