You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (Updated) (JIRA)" <ji...@apache.org> on 2011/09/29 13:22:46 UTC
[jira] [Updated] (DERBY-5437) Load all toursdb tables in one
invocation of ij
[ https://issues.apache.org/jira/browse/DERBY-5437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-5437:
--------------------------------------
Attachment: d5437.diff
Attaching a patch that loads all the tables in one invocation of ij. This reduces the time it takes to run "ant all" in my environment by 30 seconds (from 1 min 40 sec to 1 min 10 sec).
> 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
> Attachments: 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