U4-5003 - List View getting slow when number of items grows

Created by Vincent Baaij 27 May 2014, 21:05:08 Updated by Shannon Deminick 18 Aug 2014, 19:53:02

Relates to: U4-5365

Relates to: U4-4972

In a 7.1.3 site we're building I have made 3 list views for three different doctypes (all with a comparable number of fields). The first doctype currently has 18 children and loads in under a second. The time taken is coming from the Fiddler timeline for the request /umbraco/backoffice/UmbracoApi/Content/GetChildren?id=xxx&pageNumber=1&pageSize=10&orderBy=SortOrder&orderDirection=Ascending&filter=

The second doctype has 67 children and takes approx. 3.5 seconds. Still doable. The third doctype however has 284 children and takes a whopping 22.5 seconds! In my opinion about 300 children for a list view isn't an awful lot, but the time it takes to show the first ten is already almost not workable. I wonder when I'm going to get the first complaints from the editors...

When editing one of the items shown and then navigate back to the listview (i.e. by using the breadcrumb at the bottom, you have to wait the same time again.

Is there perhaps a kind of workaround by creating some special index in the database?

Comments

Sunnefa Lind 28 Jul 2014, 09:54:18

I have a list view with over 5000 children and that takes a good minute and a half to load. It doesn't seem to make a difference how many children are shown in a single page, it's like the list view fetches all the children before rendering.


Sebastiaan Janssen 14 Aug 2014, 09:02:08

Pull request for this issue: https://github.com/umbraco/Umbraco-CMS/pull/448


Priority: Major

Type: Bug

State: Fixed

Assignee: Shannon Deminick

Difficulty: Normal

Category: Editor

Backwards Compatible: True

Fix Submitted: Pull request

Affected versions: 7.1.3, 7.1.4

Due in version: 7.1.5

Sprint:

Story Points:

Cycle: