Skip to main content

A Django app to paginate querysets faster.

Project description

Issues Forks Stars License Twitter

Fast Paginator for Django

Simple speedy pagination over your large database tables.

Features

Simple Integration

FastPaginator API is compatible with Django's built-in pagination library. Only change your import statements then you're ready.

Better SQL Queries

Django's built-in pagination system builds SQL queries that have offset and limit clauses. FastPagination does not use them.

Built-in Cache System

FastPaginator has a built-in cache system. It does not cache QuerySets but caches primary keys of object lists. This provides speedup for pagination progress.

Quick Start

  1. Add "fast_pagination" to your INSTALLED_APPS setting like this:
    INSTALLED_APPS = [
        ... 
        'fast_pagination'
    ]
  1. In Django settings, you can set FAST_PAGINATION_TIMEOUT variable to invalidate cache. Default value is 1 hour.
  2. In Django settings, you can set FAST_PAGINATION_PREFIX variable to use in cache keys. Default values is 'fastpagination'.
  3. Import FastPaginator like this:
    from fast_pagination.helpers import FastPaginator
  1. Then, you are ready. All you have to do is give your queryset and number of entries when creating FastPaginator object.

To Run Tests

  1. Create a dummy project.
  2. Run following command.
./manage.py test fast_pagination.tests

Benchmark

This benchmark is executed on Postgres9.6 with a table that has 1000000 rows, and fetched only one field. Results can be seen below.

Paginator Min Max Mean StdDev Median
Django 93.5535 (1.53) 95.7217 (1.54) 94.7340 (1.53) 0.9755 (2.32) 94.9046 (1.54)
FastPaginator 61.1488 (1.0) 62.3316 (1.0) 61.7489 (1.0) 0.4205 (1.0) 61.7649 (1.0)

You can also run benchmark tests following instructions:

  1. Run migrations if app needs using
./manage.py migrate
  1. Call generate_users command from command line using
./manage.py generate_users 1000000
  1. Run tests using
pytest fast_pagination/tests.py

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django-fast-paginator-1.0.4.tar.gz (4.3 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page