[
https://jira.codehaus.org/browse/MSQL-69?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=275667#comment-275667
]
Mark Struberg commented on MSQL-69:
-----------------------------------
yup, good idea. will ping Robert and talk with him if we like to cleanup
anything else before going on with a release.
> High CPU usage of org.codehaus.mojo.sql.SqlSplitter.containsSqlEnd
> ------------------------------------------------------------------
>
> Key: MSQL-69
> URL: https://jira.codehaus.org/browse/MSQL-69
> Project: Maven 2.x SQL Plugin
> Issue Type: Bug
> Affects Versions: 1.4
> Reporter: Jochen Stiepel
> Assignee: Mark Struberg
>
> I'm executing a 73KB .sql file and it take more than 30 minutes, but it is
> not the database that uses this time it is this method:
> (Linenummer von SQL-Splitter) changes
> at org.codehaus.mojo.sql.SqlSplitter.containsSqlEnd(SqlSplitter.java:98)
> at org.codehaus.mojo.sql.SqlExecMojo.runStatements(SqlExecMojo.java:966)
> at org.codehaus.mojo.sql.SqlExecMojo.access$200(SqlExecMojo.java:66)
> at
> org.codehaus.mojo.sql.SqlExecMojo$Transaction.runTransaction(SqlExecMojo.java:1207)
> at
> org.codehaus.mojo.sql.SqlExecMojo$Transaction.access$100(SqlExecMojo.java:1154)
> at org.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:612)
> at
> org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:107)
> It used 97% of the time. 3 % is execSQL(). The time are from jvisualvm
> (included in the jdk).
> Maybe the parser should be changed to something like ANT does:
> http://svn.apache.org/viewvc/ant/core/trunk/src/main/org/apache/tools/ant/taskdefs/SQLExec.java?view=markup
> It should be possible to copy that code, or?
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email