[
https://jira.codehaus.org/browse/MSQL-69?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=275666#comment-275666
]
Florian Hopf commented on MSQL-69:
----------------------------------
I had the same problem with poor performance using 1.4, the code was hanging in
the same line in SqlSplitter. I just downloaded and compiled trunk and the
problems disappeared.
Are you planning to release a version in the near future?
> 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
