id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
30207	Optimise paginator for tables with massive records	M. Javidan Darugar	M. Javidan Darugar	"I had a problem with Paginator class to slice huge dataset. In case of millions of record it can take 30 second to reach the last page. So I cam up with a solution to overcome this problem.

The problem is that for slicing data, current solution needs to compute whole list to render data `bottom:top`. The reason is that, current script will generate for example `SELECT ID, COL_1, ..., COL_N, ... WHERE ...` which has huge burden for database to slice the data. To overcome this problem we can instead select primary keys and do the slicing step and then fetch records that their pk are in that sliced list. Very simple but very efficient solution. I improved the performance for our project significantly using this approach. So form 30 seconds to only 2-3 seconds for 8 million records.

In this ticket I propose same approach to improve django Paginator class."	Cleanup/optimization	closed	Core (Other)	dev	Normal	needsinfo		Can Sarıgöl	Unreviewed	0	0	0	0	0	0