-
Defect
-
Resolution: Cannot Reproduce
-
Minor
-
None
-
None
Some of the overall gateway reports have potential to run quite poorly. I had to add a sub-select that had at least two joins in it to make sure we're only getting data from one gateway.
I think for the sort run the reports will run fine, however, it would be interesting to see how they would run after a few years of data being added to the database.
Implementing a star schema will help elevate the need for having sub-selects and multiple join statements.
I think for the sort run the reports will run fine, however, it would be interesting to see how they would run after a few years of data being added to the database.
Implementing a star schema will help elevate the need for having sub-selects and multiple join statements.
- relates to
-
GTWY-2938 Metrics reporting
- Done