Skip to Content
0
Former Member
Jan 04, 2011 at 06:18 AM

/CRYSTAL/OSQL_EXECUTE Performance Issue

28 Views

Hello Experts,

I have few concerns regarding /CRYSTAL/OSQL_EXECUTE Program.

We have around 30 Crystal Reports (Developed on top of SAP R/3 System) which all are scheduled respectively and there are around 120 Instance are schedule from these reports respective restricted by a single vendor, company code and all.

All instances are scheduled and executed between 8 PM to 10 AM. But the program /CRYSTAL/OSQL_EXECUTE (Which comes with transport files of SAP integration kit) is getting executed around 18 to 19 hrs everyday.

I have few questions on this:

1) What is the Importance of this program?

2) What should be max. time for this program to get executed?

3) In my case, What should be reason to get long time to get executed?

4) What are necessary steps I need to follow to increase performance?

I really appreciate your views on this.

Thanks a lot in advance,

Rishit kamdar