Daniel Roseman wrote: > On Dec 11, 2:51 pm, Jean Stebens <neme...@twilightzone.lu> wrote: >> Hi there, >> >> I have a rather large set of objects in my database, around 200k, using >> the django admin interface and listing them is always terrible slow as >> it always fetches all entries (paginated). I usually just run a few >> searches or add some filters on the list. Is there a way to have the >> list not shown initially until I do add some filters/searches? >> >> Cheers, >> Jean > > This seems strange. Are you talking about the changelist view? This > never fetches all objects - it only fetches the objects for one page > at a time. > -- > DR. > > -- > > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-us...@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > Yes, I'm talking about the changelist in the admin interface. With my current set of 200k entries I have 1990 pages each containing 100 entries.
applying a filter on that initial list makes it load relative fast. I've tried commenting out any calculated fields when displaying the objects, but that doesnt improve the performance, my best guess is the initial "show all" queryset set off by the framework. Cheers, Jean -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
