Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-634

performance optimization for content loading

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.2
    • Fix Version/s: 1.2.3, 2.0.0-M1
    • Component/s: core
    • Labels:
      None

      Description

      As discussed on the dev mailing list [1]:
      On content loading from content.xml, before each insert, Syncope issues a database statement that reads the whole table content, only to get the table metadata (see ContentLoaderHandler.getParameters()).

      This can be optimized by adding "WHERE 0=1" to the query (so no records are returned, but the schema can still be obtained).

      [1] http://syncope-dev.1063484.n5.nabble.com/minor-optimization-for-content-loading-td5716645.html

        Attachments

          Activity

            People

            • Assignee:
              wimmelg Guido Wimmel
              Reporter:
              wimmelg Guido Wimmel
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: