High CPU usage of org.codehaus.mojo.sql.SqlSplitter.containsSqlEnd
------------------------------------------------------------------
Key: MSQL-69
URL: http://jira.codehaus.org/browse/MSQL-69
Project: Maven 2.x SQL Plugin
Issue Type: Bug
Affects Versions: 1.4
Reporter: Jochen Stiepel
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.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
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
