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 <mark.matthews@stripped>
> 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
