Uploaded image for project: 'Apache Guacamole - Contributions'
  1. Apache Guacamole - Contributions
  2. GUAC-1373

Improve history search performance

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 0.9.9
    • Component/s: guacamole-auth-jdbc
    • Labels:
    • Sprint:
      DEV 2015-11-27
    • Story Points:
      5

      Description

      The history search implemented within GUAC-1193 works, but will degrade in performance as the number of history records increases. Since the history table does nothing but increase, this needs to be addressed.

      It may not be possible to query the entire table efficiently in 100% of cases, but the scope of the query should at least be intelligently limited such that the most relevant data is returned without necessarily iterating through every single of several million rows.

      This could be achieved by estimating the start position of the first relevant row (based on sort order and query string content), and querying through only the first 10,000 or so rows in the vicinity of that row.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              mike.jumper Michael Jumper
              Reporter:
              mike.jumper Michael Jumper
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: