Opened 20 months ago
Closed 19 months ago
#2296 closed enhancement (fixed)
Improve performance when loading many any-to-any links
Reported by: | Nicklas Nordborg | Owned by: | everyone |
---|---|---|---|
Priority: | major | Milestone: | BASE 3.19.8 |
Component: | core | Version: | |
Keywords: | Cc: |
Description
The use case is that we have long list of items (of the same known item type) and want to load the same named any-to-any link for all of them. This is typically done with:
AnyToAny link = AnyToAny.getByName(...); XxxxItem linkedItem = link.getTo();
This typically require two extra database calls. One call to load the link and one to load the linked item. Performance for this is bad when we have to repeat this many times.
To increase the performance the idea is to implement a helper object that can load all links with a single query and all target items with a single query.
Change History (3)
comment:1 by , 20 months ago
comment:3 by , 19 months ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
In 8130: