| Key: |
SAK-6039
|
| Type: |
Task
|
| Status: |
Closed
|
| Resolution: |
Fixed
|
| Priority: |
Minor
|
| Assignee: |
Unassigned
|
| Reporter: |
Stephen Marquard
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
| 2.6.x Status: |
None
|
| 2.5.x Status: |
None
|
| 2.4.x Status: |
None
|
|
DbAuthzGroupService has 3 queries which have different versions for Oracle/hsql vs mysql, viz.:
* read the roles and role functions
* read the role descriptions
* read the role grants
The mysql versions of these queries were changed to use joins rather than subselects, as subselects are not optimized correctly by mysql and are thus a performance problem.
It's possible that these versions can be used for all 3 databases with minor changes, _if_ performance of joins vs subselects is either better or the same on Oracle for these queries (opinions seem to vary).
If so, it would be preferably for code maintainability to have a single version of each query rather than vendor-specific versions.
|
|
Description
|
DbAuthzGroupService has 3 queries which have different versions for Oracle/hsql vs mysql, viz.:
* read the roles and role functions
* read the role descriptions
* read the role grants
The mysql versions of these queries were changed to use joins rather than subselects, as subselects are not optimized correctly by mysql and are thus a performance problem.
It's possible that these versions can be used for all 3 databases with minor changes, _if_ performance of joins vs subselects is either better or the same on Oracle for these queries (opinions seem to vary).
If so, it would be preferably for code maintainability to have a single version of each query rather than vendor-specific versions.
|
Show » |
|
Collapse vendor-specific sql into generic sql in DbAuthzGroupService