US and Worldwide: +1 (866) 660-7555
Results 1 to 9 of 9

Thread: PDI 4.3 GA executable load times excessive

  1. #1

    Unhappy PDI 4.3 GA executable load times excessive

    I just downloaded PDI 4.3 GA and found that starting up spoon and kitchen is taking at least 1-2 mins. My transformations actually run in less time that it takes to start up. Does anyone else have this issue?

    The environment is as follows:
    Windows 7 (64-bit)
    JRE 1.6 Build 32 64-bit
    2xQuad Core CPU
    8GB RAM (2GB allocated to PDI JVM)

    It is unacceptable if I'm trying to run near real-time refreshes.

  2. #2
    Join Date
    Apr 2008
    Posts
    805

    Default

    It is unacceptable if I'm trying to run near real-time refreshes.
    Don't use Spoon (the GUI) but use pan or kitchen (command line).
    Especially if you have to run a job/transformation at specific intervals then you should better create a batch file (in Win) that launches pan/kitchen.

    Mick

  3. #3

    Default

    I am using kitchen called with a batch file.... My original post says both kitchen and spoon are taking an excessive amount of time to load.

  4. #4
    Join Date
    Nov 1999
    Posts
    9,535

    Default

    That's indeed excessive. We're working on trimming down the startup time of Spoon from something like 10 seconds down to 2. Minutes of start-up time is either an exageration on your behalf or a special setup problem.
    So I would try to see if you perhaps have a bunch of JRE's installed and I would try to remove all un-used plugins (that always helps) from the plugins/ folder.
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

  5. #5
    Join Date
    Nov 1999
    Posts
    9,535

    Default

    For real-time stuff you best set up a never-ending job or something like that.
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

  6. #6

    Default

    I timed it once more and it took 1:04.1 I'm using only one JRE which is specified in the PENTAHO_JAVA_HOME environment variable. I'll try the plug-ins removal to see if that helps out. It didn't (and still don't) have this issue with the preview release of 4.3 so there must be some changes in the GA (or plug-ins delivered with it) that have caused it.

  7. #7
    Join Date
    Nov 1999
    Posts
    9,535

    Default

    On certain occasions I've seen the Agile BI embedded web server time out, that could cause it. You'll see if you remove the Agile-BI plugin. Perhaps it's caused by a specific network configuration?
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

  8. #8

    Default

    Quote Originally Posted by MattCasters View Post
    On certain occasions I've seen the Agile BI embedded web server time out, that could cause it. You'll see if you remove the Agile-BI plugin. Perhaps it's caused by a specific network configuration?
    Yes! Dumping the Agile-BI plugin put the time down to 5 sec...thanks Matt! I do have a tomcat instance on the machine so they probably have conflicting configurations. Nice to see that the management still hasn't forgotten how their product works

  9. #9
    Join Date
    Nov 1999
    Posts
    9,535

    Default

    Like I said, we're working on solving the issue :-)
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

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
  •