U4-9450 - Paged data queries return all property data in the entire database, not just for the paged subset

Created by Shannon Deminick 31 Jan 2017, 02:46:26 Updated by Sebastiaan Janssen 09 Feb 2017, 20:02:56

Relates to: U4-9494

Relates to: U4-9447

Subtask of: UAASSCRUM-790

When we page data we lookup the document data first, then we lookup the property data. It turns out that when we lookup this property data, the paged subset is not taken into account which means we actually query against all of the property data in the db!

This means that if there is 500,000 rows in the property data, and we are executing a paged query where the page size is only 10 documents, we would still fetch all 500,000 property data rows and then filter then to combine with the 10 documents which obviously is incredibly inefficient. Instead when fetching the property data rows we inner join the query on the paged document dataset to only return the property data rows for the 10 documents.

Comments

Shannon Deminick 31 Jan 2017, 03:02:35

PR https://github.com/umbraco/Umbraco-CMS/pull/1715


Sebastiaan Janssen 09 Feb 2017, 20:02:50

All seems to work beautifully :)


Priority: Major

Type: Bug

State: Fixed

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions:

Due in version: 7.5.10

Sprint: Sprint 52

Story Points:

Cycle: