View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004484 | Composr | core | public | 2020-11-26 16:33 | 2020-11-26 16:33 |
| Reporter | Chris Graham | Assigned To | |||
| Severity | Feature-request | ||||
| Status | non-assigned | Resolution | open | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0004484: Tree structure cache | ||||
| Description | For large category structures, it is necessary to have a cache table for all the structural relationships going all the way down the tree, to be able to find all categories that exist underneath another without recursion. catalogue_cat_treecache does this for catalogue categories already. Doing this, and adjusting our framework to use it consistently, would allow the "search under" code to be much more efficient. Instead of recursing to find all categories under another, it could just note to search under that specific category and have the check does in SQL using an EXISTS clause. | ||||
| Tags | Type: Performance | ||||
| Time estimation (hours) | 16 | ||||
| Sponsorship open | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-11-26 16:33 | Chris Graham | New Issue | |
| 2020-11-26 16:33 | Chris Graham | Tag Attached: Type: Performance |
