Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: taking too much time......?

  1. #1

    Default taking too much time......?

    hi,
    i am using pentaho_report_designer and i created a report with oracle as database. but whenever i try to preview data and try to run a report, it takes too much time like 1 hr.
    is there any solution to improve such a performance.
    thanks.

  2. #2
    dmoran Guest

    Default Re:taking too much time......?

    yes.

  3. #3
    Join Date
    Mar 2006
    Posts
    683

    Default Re:taking too much time......?

    You might want to check to make sure you have indexed everything to increase the proformance.

    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

  4. #4

    Default Re:taking too much time......?

    can you elaborate more please?

  5. #5
    Join Date
    Mar 2006
    Posts
    683

    Default Re:taking too much time......?

    uhmm.
    a couple things to look out.
    One Query Optimization
    Two Indexes on tables
    Three number of joins
    Four DB Optimization


    Hope that helps.

    Nic

    Post edited by: guzaldon, at: 08/02/2006 15:50
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

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.