#4484 - Tree structure cache
-
By Chris Graham
- Added
- 1 view
| Identifier | #4484 |
|---|---|
| Issue type | Feature request or suggestion |
| Title | Tree structure cache |
| Status | Open |
| Tags |
Type: Performance (custom) |
| Handling member | Deleted |
| Addon | core |
| 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. |
| Steps to reproduce | |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
There have been no comments yet