[SYNCOPE-634] performance optimization for content loading

• 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
• Assignee: Guido Wimmel
• Reporter: Guido Wimmel
• Created: 10/Feb/15 09:29
• Updated: 20/Mar/15 08:52
• Resolved: 10/Feb/15 11:00

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