Hello all,
we are facing very bad performance with Crystal and SAP INfoset. So i did some analysis.
When i run the Query directly in R/3 it takes about 15 seconds to get the result (about 900 rows). This would be the time we can accept in Crysal...
Crystal needs about 5 Minutes to show the result. The time is spent with reading the database records (292472 ms)
When I checkd the RFC-Trace on the ERP-System i saw the follwoing, which repeats during the whole runtime of the report. I also saw in SM50 that the process is generating the query again and again.
RFC-Trace:
170.280 RZ184_BD3 Server 1 0 RZ280 RZ184_BD3_00 Server /CRYSTAL/CALL_QUERY 2.816 952
52.556 RZ184_BD3 Server 1 0 RZ280 RZ184_BD3_00 Server RSAQ_REMOTE_QUERY_DELETE 146 194
55.943 RZ184_BD3 Server 1 0 RZ280 RZ184_BD3_00 Server RSAQ_REMOTE_QUERY_GENERATION 310 1.278
307.157 RZ184_BD3 Server 1 0 RZ280 RZ184_BD3_00 Server /CRYSTAL/GET_QUERY_INFO 6.206 256
So my question. Does anybody know the reason for this, and how can I avoid this, because most time is spent for /Crysal/GET_query_info.
Thanks a lot
bR
Markus