Re: A faster paginator for django

2018-12-23 Thread Tim Allen
On Friday, December 21, 2018 at 10:18:04 AM UTC-5, Cristiano Coelho wrote: > > Let's not forget how the various *count *calls starts to kill your > database when you get over 1 million rows (postgres at least). > > So far the only options I have found with postgres are: > - Estimate count for non

Re: A faster paginator for django

2018-12-23 Thread Dan Davis
Also, it can be worse than one count query. When interacting with datables.net serverSide, you will need multiple count queries. On Sat, Dec 15, 2018, 10:32 AM Kye Russell It might also be worth looking at the alternative pagination methods > offered by Django REST Framework as a source of inspir

Re: A faster paginator for django

2018-12-23 Thread Tom Forbes
I would be strongly against misusing EXPLAIN like that inside Django, and I feel keyset/cursor pagination is best if your going down this road. I've got no concrete evidence for this opinion, but I feel like navigating to an exact page is very rarely used and only then as a proxy for range filteri

Re: A faster paginator for django

2018-12-23 Thread Adam Johnson
(I think you meant https://datatables.net/ ? ) :) On Sun, 23 Dec 2018 at 19:25, Dan Davis wrote: > Also, it can be worse than one count query. When interacting with > datables.net serverSide, you will need multiple count queries. > > On Sat, Dec 15, 2018, 10:32 AM Kye Russell >> It might also b

Re: Integrate dj-database-url into Django

2018-12-23 Thread Raffaele Salmaso
Hi all, I'm working on https://github.com/django/django/pull/10786 (which is a port of https://pypi.org/project/django-service-urls/ , which is a 'fork/rewrite' of Tom PR). I need to (re)read all these emails to find ideas to improve the PR/package. On Sat, Jul 28, 2018 at 9:44 PM Tom Forbes wrot

Re: A faster paginator for django

2018-12-23 Thread Dan Davis
Yes, https://datatables.net/, often miscalled jquery datatables, it is more like php datatables in its CGI parameters ;) On Sun, Dec 23, 2018 at 2:51 PM Adam Johnson wrote: > (I think you meant https://datatables.net/ ? ) :) > > On Sun, 23 Dec 2018 at 19:25, Dan Davis wrote: > >> Also, it can b

Re: A faster paginator for django

2018-12-23 Thread Dan Davis
To be honest, I just entered it as a word, and the client made it a URL because it ends with a top-level domain, and looks like a domain name. On Sun, Dec 23, 2018 at 7:15 PM Dan Davis wrote: > Yes, https://datatables.net/, often miscalled jquery datatables, it is > more like php datatables in i