[
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