Uploaded image for project: 'Gateway'
  1. Gateway
  2. GTWY-144

Reporting Star Schema Requirement

XMLWordPrintable

      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.

              wilhelmi Nathan Wilhelmi (Inactive)
              nhook Nathan Hook
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: