Hi, I am using a recent svn checkout of django and:
Paginator(User.objects.all(), 20) results in the following SQL query: SELECT "auth_user"."id", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."password", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."is_superuser", "auth_user"."last_login", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."is_active" = true ORDER BY "auth_user"."date_joined" DESC As you can see there is no LIMIT in this query and it takes quiet a long time to execute (about 0.2 sec.) Shouldn't the paginator be adding the apropriate LIMIT clause? Am I missing something? Thanks, omat --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
