Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-8139

Build off-line versions of event and session tables

    XMLWordPrintable

    Details

    • Type: Feature Request
    • Status: CLOSED
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.2.0, 2.2.1, 2.2.2, 2.3.0, 2.3.1
    • Fix Version/s: None
    • Labels:
      None
    • Previous Issue Keys:
      REQ-412

      Description

      Currently these spool off into space for all perpetutity - most folks clean these out from time to time to keep the tables from getting too big. What we need to do is capture and store this data efficiently for report generation and querying.

      It might be nice to come up with a way to automate a process where these get moved from the "live" tables to the offline tables every 30 minutes or so. The structure of the offline tables could actually be slightly different than the online tables and tuned to make queries run really fast. Ultimately the queries for the SiteStats tool could union between the (now much smaller) online tables and the offline tables to get the data so the users would ever see the "30 minute lag" - but things would perform nicely.

      Then, over time, we could take the off line tables and store them by semester or something like that.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    csev Charles Severance
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Git Integration