Thanks very much Ludovic for the advice. On Oct 31, 2016 9:53 AM, "ludovic coues" <cou...@gmail.com> wrote:
> I would use 1 + 2 from your list. > > 3 might work on 1000 record, depending on how much data there is per > record. But if you grow to more than 10,000 record, the page loading > can take minutes. I have experienced that issue with two different > project. > > Django pagination by itself won't give you the infinite scroll you are > expecting. But it should give you an easy interface for slicing the > data from your db. > > An easier way might be class based view. The following exemple create > a view to a list of object, paginated: > > from django.http import JsonResponse > from django.views.generic import ListView > > class ModelListView(ListView): > model = RecordModel > paginate_by = 20 > > It will try to use the template at app/record_model_list.html, the > context will have the keys paginator, page, is_paginated, object_list. > You can override the method render_to_response to return a json > response. > The documentation on ListView is at [1] and there is an exemple for > returning JsonResponse at [2] > > > [1] https://docs.djangoproject.com/en/1.10/topics/class- > based-views/generic-display/ > [2] https://docs.djangoproject.com/en/1.10/topics/class- > based-views/mixins/#more-than-just-html > > > > > 2016-10-31 2:04 GMT+01:00 ADEWALE ADISA <solixzsys...@gmail.com>: > > Hello, > > Please I need an advice on the best approach to take on the following > > issues. > > I have a database table consist of about 1000 record. I need to be > > displaying like 20 records at a time on a page such that when the user > > scroll the browser another batches will be append to the browser. > > Below are the 3 ways am aiming to achieve this: > > > > 1. Using django pagination feature. > > > > 2. Everytime records need to be appended to the browser , an ajax call is > > made to the view, then the queryset is slice using appropriate lower and > > upper band. Then the returned record is appended to the browser. > > > > 3. Fetch the whole records from the database and transfer everything to > the > > browser, then JavaScript is now use to slice and be appending as needed. > > > > NOTE: The webpage would work like yahoo.com mobile site. > > Please with approach is the best in term of performance and speed. > > > > Thanks. > > > > -- > > You received this message because you are subscribed to the Google Groups > > "Django users" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to django-users+unsubscr...@googlegroups.com. > > To post to this group, send email to django-users@googlegroups.com. > > Visit this group at https://groups.google.com/group/django-users. > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/django-users/CAMGzuy8cK7ueHGPwuCjbrV- > SdfZwkYYhg7_t7-Dmmt%3D6g787YA%40mail.gmail.com. > > For more options, visit https://groups.google.com/d/optout. > > > > -- > > Cordialement, Coues Ludovic > +336 148 743 42 > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To post to this group, send email to django-users@googlegroups.com. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/django-users/CAEuG%2BTaPWphYQAwa9-rPW5VZ93yyA3kL% > 3Dz8JAecdLRMiKdjihA%40mail.gmail.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAMGzuy_Tu7mdL4RTvNGWY%3Dm5PL0ttT4wv9QKeMfiLqd43MiaVw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
