Re: insert batch & execute performance

[Globe Trotter]

Hi,

thanks for your reponse.

No it doesn't doing even with rewriteBatchedStatements = true! I use normally 4.0, but even 4.1 same results. I could before save in batch, but to my regret after a modification not more! Same code. I think I modified any variable of mysql and then I destroyed. In normal case it needs 60milli for one save, but now 700milli! 10x more!

Which all variables can influence it!? I don't think, that there is a bug in source. I use JDK 1.8 and mysql-connector-java-5.1.48.jar for JDBC. But I even have tried all older versions of connector.

The connection string is "jdbc:mysql://localhost/" + database + "?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true";

Thanks.

GT