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.datab...@phi-integration.com> wrote: > Hi Mark, > > On Thu, Dec 16, 2010 at 4:50 AM, Mark Matthews <mark.matth...@oracle.com> > 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
