From: Johan De Meersman Date: December 16 2010 9:03am Subject: Re: Bulk Insertion Performance List-Archive: http://lists.mysql.com/mysql/223803 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=90e6ba53acf4f71848049783534b --90e6ba53acf4f71848049783534b Content-Type: text/plain; charset=ISO-8859-1 Hmm, interesting. What does this do, exactly ? Can something similar be applied to non-jdbc connections, too ? On Thu, Dec 16, 2010 at 8:34 AM, Feris Thia < milis.database@stripped> wrote: > Hi Mark, > > On Thu, Dec 16, 2010 at 4:50 AM, Mark Matthews > wrote: > > > Feris, > > > > I don't know what Kettle is doing under the hood, but if it's doing > > addBatch(), executeBatch(), then adding "rewriteBatchedStatements=true" > to > > your MySQL JDBC URL should probably help quite a bit. > > > > It works. By having rewriteBatchedStatements=true in the jdbc url it > increases. Now it performs an average 4500 rows / second. Thanks Mark. > > Regards, > > Feris > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --90e6ba53acf4f71848049783534b--