[FOLIO-705] implement intra-module joins/views to enable sorting on linked fields Created: 03/Jul/17 Updated: 12/Nov/18 Resolved: 24/Jul/17 |
|
| Status: | Closed |
| Project: | FOLIO |
| Components: | None |
| Affects versions: | None |
| Fix versions: | None |
| Type: | Task | Priority: | P2 |
| Reporter: | Jakub Skoczen | Assignee: | shale99 |
| Resolution: | Done | Votes: | 0 |
| Labels: | core, sprint18, team2 | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Issue links: |
|
||||||||||||||||||||||||||||
| Sprint: | |||||||||||||||||||||||||||||
| Description |
|
This will be applicable only in case where data for the main object and data for the related object (on which we want to sort) lives in the same storage modules. Those use cases happen to be most pressing though (see
|
| Comments |
| Comment by shale99 [ 03/Jul/17 ] |
|
one issues i guess i have is that i do not know what the performance would be like. this would of course be a view which is a join of two tables - what is the performance impact of running a join on two separate tables? - there may not be a difference if it just using indexes - if that is the case then this sounds like a reasonable solution |
| Comment by shale99 [ 04/Jul/17 ] |
|
actually, why a view, why not just run join queries where needed? |
| Comment by Julian Ladisch [ 15/Jul/17 ] |
|
A view is a join than can easily be reused and makes the queries more readable. |