A django paginator for RawQuerySet. This allows you to pass a RawQuerySet into a custom paginator, resulting in more efficient pagination. Supports mysql, sqlite, and postgresql. Oracle 12.1 and Firebird support needs testing.
Installing the dev version:
pip install git+git://github.com/seamusmb/django-paginator-rawqueryset.git
Add 'rawpaginator' to your INSTALLED_APPS in settings.py
if you want a Paginator that can work with querysets, lists, and rawquerysets, use the rawpaginator.paginator.Paginator wrapper class:
from rawpaginator.paginator import Paginator
raw_qs = some_model.objects.raw("""SELECT * FROM some_model""")
p = Paginator(raw_qs, 50)
p.page(1)
It's also possible to import the RawQuerysetPaginator, if you don't trust the wrapper. However, it should work for all use cases:
from rawpaginator.paginator import RawQuerySetPaginator
raw_qs = some_model.objects.raw("""SELECT * FROM some_model""")
p = RawQuerySetPaginator(raw_qs, 50)
p.page(1)
In my tests, I'm getting up to 50% performance gains using this, mainly when paginating a large complex query. Don't bother using this for simple queries with a few pages, stick to the default paginator and cast the RawQuerySet to a list.
Tested with Django 2 and Python 3