Skip to Content
0
Former Member
Jan 04, 2012 at 08:22 AM

Performance Issue with Crystal 11 on top of SAP Infoset/Query

52 Views

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