Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Performance Issue with PDI

  1. #1
    Join Date
    Jul 2016

    Post Performance Issue with PDI

    Hi All,

    I am facing performance issue with penatho code running on MS-SQL-SERVER data base.It took 3hrs time to complete the tranformation with data count nearly 6 Millions records.
    But same code when I ran on Oracle data base with same data count, The Transformation completing within 15 mins time.

    Need Help to find root cause for this performatnce issue, I am using JDBS driver for MS-Server Connection as my DB connection.
    Please HELP me to know any DB changes need to be done on SQL_SERVER database connections to optimize the performance.

    Thanks In Advance.

    Last edited by jilan_etl; 02-17-2017 at 03:26 AM.

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.