openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Romain Manni-Bucau <rmannibu...@gmail.com>
Subject Re: MySQL batch insert
Date Sun, 03 Feb 2013 21:40:02 GMT
oops,

seems rewriteBatchedStatements=true in the jdbc url + <property
name="openjpa.jdbc.DBDictionary" value="batchLimit=-1"/> should do the same

sorry for the useless mail

*Romain Manni-Bucau*
*Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
*Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
*LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
*Github: https://github.com/rmannibucau*



2013/2/3 Romain Manni-Bucau <rmannibucau@gmail.com>

> Hi,
>
> i didnt find any way to use batch insert for MySQL, would it be possible
> to get it?
>
> ex: INSERT INTO Foo (a,b,c) VALUES(1,2,3),(4,5,6);
>
> Would be great to get some perf improvement for app having multiple
> inserts in the same transaction.
>
> *Romain Manni-Bucau*
> *Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
> *Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
> *LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
> *Github: https://github.com/rmannibucau*
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message