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, do this:
from rawpaginator.paginator import Paginator
raw_qs = some_model.objects.raw("""SELECT * FROM some_model""")
p = Paginator(raw_qs, 50)
p.page(1)or if you just want the RawQuerySetPaginator, you can do this:
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