Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to Improve performance of table output

  1. #1
    Join Date
    Apr 2014
    Posts
    6

    Default How to Improve performance of table output

    Hello,

    I am fetching the millians of records from source to Target
    Source -- oracle DB 12.1.3
    Target -- MySQL 5.5

    I am using table input step and table output step.
    input/output steps inserting 3 rows per sec.
    Can anybody give me suggestions, how to improve performance of input/output steps.

    Thankyou,
    Satya

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    That seems unusually slow. How wide are the rows? Are you dependent on a slow network?

    For further troubleshooting, try reading the source data from Oracle and dumping it to a local CSV file. Then try reading the local CSV file and writing it to MySQL. Those two tests might help isolate the bottleneck.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

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.