Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009
    Posts
    24

    Unanswered: query in crystal takes much more time

    Salutte,

    i have a query that runs in crystal reports very long. When I execute that query in a jcc-connection (jdbc) it's much faster.

    Are there any differences? Would it be better/faster to create a stored proc and call it from crystal?

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by saez View Post
    Salutte,

    i have a query that runs in crystal reports very long. When I execute that query in a jcc-connection (jdbc) it's much faster.

    Are there any differences? Would it be better/faster to create a stored proc and call it from crystal?

    Thanks.
    My guess is that the two queries are not identical and that is the reason for the difference. It is our experience that stored procedures work exceptionally well with crystal. This gives better control of the query since it can be tuned easier.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •