Getting timeout error while executing my report

[Former Member]

Hi experts,

I need to get data from a Ztable which is having more than 64 millions of records. That query itself is taking more than 20 min to execute. I have used package size while retrieving tha data but still taking same time to execute, Giving me the TIMEOUT error .

Provide some suggetions to use different types of SELECT quries that can be used to improve the performance.

Thanks & Regards,

Bhanu

[Sandeep_Panghal]

1.use OPEN CURSOR with package size

2. try to process the program in background and also

[Jelena_Perfiljeva]

There is a separate forum dedicated specifically to the performance issues, there are many suggestions already available there. Please use Search. Also use the standard performance analysis tools available in SAP.

If the program has already been optimized to the max, you might want to consider running in "batches". E.g. create a parameter (e.g. a date) to limit selection and run the program several times.

In any case, a program that is reading 64 mil. records should not be run in foreground. Also I'd question its purpose and the business requirements for such program.

[Former Member]

Hi ,

I am working as an abaper for Service Management module.

I need to show the prmise details inthe output of alv. Before that i need to get the meter reading details and need to do some calculations, by which i need to show idle one (Here only i need to hit a ZTABLE which is having more than 64 million records). For that idle premise user can select multiple pemises by using check boxes and can create notification by pressing a pushbutton 'CREATE IS NOTIFICATION' which exist on the application toolbar . So i can not run this report in background.

Thanks & regards,

Bhanu.

[Former Member]

Resolved.