Task #1619
closed
Filtering of entities generate too many selects
Added by Vít Švanda over 5 years ago.
Updated over 5 years ago.
Description
Example:
I have identity with 50 identity-account rows. If filter by identityId is executed, then 1 select for identity-accounts and 50 for every items are executed.
- Description updated (diff)
- Assignee changed from Vít Švanda to Radek Tomiška
- Status changed from In Progress to New
- Target version changed from Quartz (9.6.0) to Rhyolite (9.7.0)
- Status changed from New to In Progress
- Status changed from In Progress to Needs feedback
- Assignee changed from Radek Tomiška to Vít Švanda
- % Done changed from 0 to 50
- Target version changed from Rhyolite (9.7.0) to Quartz (9.6.0)
- Assignee changed from Vít Švanda to Radek Tomiška
- % Done changed from 50 to 100
I checked same place as first time: Find identity account AbstractProvisioningExecutor#doProvisioning row 206. Identity with 13 identity account:
Before your changes: 38 queries. Time: 290 ms
After your changes: 18 queries. Time: 15 ms
The speedup this queries is about ~19x!!!
This new feature works for all subqueries. Thank you. Good job!
Good job!
- Status changed from Needs feedback to Resolved
- Status changed from Resolved to Closed
Also available in: Atom
PDF
