Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Kettle: Insert/Update is too slow process!!

  1. #1
    Join Date
    Oct 2014
    Posts
    5

    Default Kettle: Insert/Update is too slow process!!

    Hi,
    i am new to kettle. i have created a transformation to load bulk data around 4 lac, using SQLserver as both source and destination. i am ussing Insert/Update tool to write data in to destination. i only get 50 records per second, so it's takes many hours to load complete data. So how can i increase the no of records per second??
    Please help...
    Thanks.

  2. #2
    Join Date
    Oct 2013
    Posts
    216

    Default

    Check for at least one index on destination table, and In Insert/Update transformation you can increase commit size.. This will increase your Speed.
    -- NITIN --

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.