[jira] Commented: (IBATIS-425) Improving startup time (Dynamically loading SQL maps based on namespace)

["Claus Ibsen (JIRA)" <ib...@incubator.apache.org>]

    [ https://issues.apache.org/jira/browse/IBATIS-425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493915 ] 

Claus Ibsen commented on IBATIS-425:
------------------------------------

Great idea.

> Improving startup time (Dynamically loading SQL maps based on namespace)
> ------------------------------------------------------------------------
>
>                 Key: IBATIS-425
>                 URL: https://issues.apache.org/jira/browse/IBATIS-425
>             Project: iBatis for Java
>          Issue Type: Improvement
>          Components: SQL Maps
>    Affects Versions: 2.3.0
>         Environment: Windows XP/Oracle 10g
>            Reporter: Tyler Van Gorder
>
> We have a very large schema (400+ Tables) and we are using a code generator to create SQLmaps and value objects for each table. This gives us a boiler plate map for CRUD operations for every table in the system. The problem is that it is taking 11 seconds to parse/load all the SQL maps. We had a similar problem when we used hibernate and eventually added a patch to load the configuration dynamically as it was used for the first time in the application. Why do we want to do this? Well, it significantly speeds up the development/unit testing cycle. I know that 11 seconds is not horrible, but it does add up if you are running your unit tests 50-60 times a day * 5 developers.
> How hard would it be to add a "namespace" attribute in the sqlMap entries in the sqlMapConfig and then read all SqlMap entries into a hashmap where the key is the names pace. Then as the application asks for a statement/query from the SQLmap, if the name space of the statement has not yet been loaded, parse the SQL MAP keyed to the name space.
> That way you get dynamic loading of the SQL maps as their name spaces are encountered in the application.
>  

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.