List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:December 16 2010 9:03am
Subject:Re: Bulk Insertion Performance
View as plain text  
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

Thread
Bulk Insertion PerformanceFeris Thia15 Dec
  • Re: Bulk Insertion PerformanceMark Matthews15 Dec
    • Re: Bulk Insertion PerformanceFeris Thia15 Dec
      • Re: Bulk Insertion PerformanceMark Matthews15 Dec
        • Re: Bulk Insertion PerformanceFeris Thia16 Dec
          • Re: Bulk Insertion PerformanceJohan De Meersman16 Dec
            • Re: Bulk Insertion PerformanceFeris Thia19 Dec