Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Crystal 2008 and Oracle Stored Procedures performance.

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Charlotte Chase
Basic Member
Posts: 8
Basic Member
1/12/2010 8:08 PM

    Crystal 2008 and Oracle Stored Procedures performance. I am benchmarking a report that uses the native Oracle driver and an Oracle stored procedure with a ref_cursor on a Crystal 2008 report. The performance is horrible when compared to using a SQL command directly in the report. Anyone have experience with this? Is there a way to use a bulk collect rather than the ref_cursor to improve performance?

    Chris Martin
    Veteran Member
    Posts: 277
    Veteran Member
    1/13/2010 6:58 PM
      I haven't tried this yet. You might have better luck posting this to a BO forum.
      Charlotte Chase
      Basic Member
      Posts: 8
      Basic Member
      1/13/2010 7:57 PM

        Yes, you are right. Thx, I've posted to BOB, too. If I get a good solution  I'll share it here.