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