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?
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.