Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Speed of rows when using remote database

  1. #1

    Default Speed of rows when using remote database

    Hi,
    When i was trying to dump data from a remotedatabase to my local database the speed of rows is very slow. can someone please help how to increase the speed?
    Here the two databases are of different types.

    Thanks,
    Srinivas
    Last edited by balsu333; 07-06-2012 at 02:54 AM.

  2. #2

    Default

    Hi,
    can some one help please........

  3. #3
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    It really depends on many factors:
    network speed
    configuration on DB
    etc...

    Mick

  4. #4

    Default

    hi Mick,
    Thanks for reply. So i can conclude that there no component or option exist to speedup the row dumping

    Thanks,
    Srinivas

  5. #5
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    To upload records to database you can try "Bulk loader" steps (http://wiki.pentaho.com/display/EAI/...egration+Steps) instead of a Table Output step.

    You can google for more options that you can change in your DB.

    Mick

  6. #6

    Default

    Hi Mick,
    But there is a chance of data error while we are dealing with bulk loads. Right???. Any way thanks. I will go with that

    Thanks,
    Srinivas
    Quote Originally Posted by Mick_data View Post
    To upload records to database you can try "Bulk loader" steps (http://wiki.pentaho.com/display/EAI/...egration+Steps) instead of a Table Output step.

    You can google for more options that you can change in your DB.

    Mick

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.