[OPENIDM-13302] Modify VertexEdgeTableHandler to utilize WITH clause in supporting DBs. Created: 28/May/19 Updated: 21/Feb/20 Resolved: 19/Jun/19 |
|
Status: | Closed |
Project: | OpenIDM |
Component/s: | Module - Relationships, Performance |
Affects Version/s: | 7.0.0 |
Fix Version/s: | 7.0.0 |
Type: | Bug | Priority: | Major |
Reporter: | jason vincent | Assignee: | jason vincent |
Resolution: | Fixed | Votes: | 0 |
Labels: | DIXON | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Target Version/s: | |
Verified Version/s: | |
Story Points: | 3 |
Sprint: | 2019.8 - IDM |
Description |
The Vertex-Edge link expansion mega-query can utilize the WITH clause SQL syntax to improve performance on the DB's that support it. MySQL <8 don't support it, but all others do. |
Comments |
Comment by Alexander Dracka [ 21/Feb/20 ] |
Fixed |