Paginator failed to use 'limit' statement for MySQL

[nicholasdsj@…]

# paginator.py:36
    def _get_count(self):
        "Returns the total number of objects, across all pages."
        if self._count is None:
            self._count = len(self.object_list)
        return self._count
    count = property(_get_count)

len(self.object_list) will force a query without 'limit' statement, it's very severe problem. Instead of using len() method, an alternative way is to use self.object_list.count()

[James Bennett]

Paginator is meant to work with any arbitrary iterable of objects, and so cannot assume that a QuerySet-specific method is available. If you're paginating a QuerySet, use QuerySetPaginator instead, which is in the same file and uses count().