I work with large database (over 23,000,000 records mssql) and find out that Django Paginator works too slow. So basically is it a problem with database (perhaps, we should do some optimizations in db) or Django Paginator is a bad solution in this case?
Db - MS SQL
paginator = Paginator(qs, max(qs.count()))