[ 
https://issues.apache.org/jira/browse/DERBY-5437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Knut Anders Hatlen resolved DERBY-5437.
---------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.9.0.0

Committed revision 1179786.
                
> Load all toursdb tables in one invocation of ij
> -----------------------------------------------
>
>                 Key: DERBY-5437
>                 URL: https://issues.apache.org/jira/browse/DERBY-5437
>             Project: Derby
>          Issue Type: Improvement
>          Components: Demos/Scripts
>    Affects Versions: 10.9.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>             Fix For: 10.9.0.0
>
>         Attachments: d5437-2.diff, d5437.diff
>
>
> The toursdb example database is built as part of "ant all". Currently, 
> java/demo/toursdb/build.xml invokes ij nine times, as well as a custom Java 
> program (toursdb.insertMaps) once, to create the database, and all of these 
> run in separate Java processes. This means the database engine is cold booted 
> 10 times, which can take considerable time.
> There is already a script called loadTables.sql, which calls 
> loadCOUNTRIES.sql, loadCITIES.sql, loadAIRLINES.sql, loadFLIGHTS1.sql, 
> loadFLIGHTS2.sql, loadFLIGHTAVAILABILITY1.sql and 
> loadFLIGHTAVAILABILITY2.sql. I propose that we use that script instead of 
> invoking each of the sub-scripts separately. This would reduce the number of 
> times the database engine would have to be booted from 10 to 4 per full build.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to