Re: Bulk Insertion Performance

[Feris Thia]

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