Guido Wimmel created SYNCOPE-634:
------------------------------------

             Summary: performance optimization for content loading
                 Key: SYNCOPE-634
                 URL: https://issues.apache.org/jira/browse/SYNCOPE-634
             Project: Syncope
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.2.2
            Reporter: Guido Wimmel
            Priority: Minor
             Fix For: 1.2.3, 1.3.0


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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to