topic Re: Reports executing very slow in Application Development and Automation Discussions

Reports executing very slow

Former Member — Tue, 30 Sep 2008 03:18:19 GMT

Hi,

I have made a Z Report "Daily Distach Statement" . It is working perfect and show result with in 20-25 seconds. but when this report is executed by 5-6 users in same time then its take more than 600 seconds. So what is the reason behind this.What should i do in my code ? if anyboady has solution pls reply me.

thanks and regards

Rakesh

Re: Reports executing very slow

Former Member — Tue, 30 Sep 2008 04:08:41 GMT

Hi Rakesh,

Check whether the report is updating any database table. Seems that when one user executes the report..he puts a lock on a particular table & hence others have to wait untill the lock is release.

Check transaction SM12 while the reports are executed. It will give a list of tables which are locked.

Best regards,

Prashant

Re: Reports executing very slow

Former Member — Tue, 30 Sep 2008 04:13:54 GMT

Hai

I think you must use lock objects..

enqueue and dequeue function Modules

and check the locks in SM12 and SM13

Regards

Devanand

Re: Reports executing very slow

Former Member — Tue, 30 Sep 2008 04:17:28 GMT

Hi,

Re: Reports executing very slow

Former Member — Tue, 30 Sep 2008 04:21:16 GMT

Hi,

Thanks for reply, But here I am not updating any data base table... only i fetch data from database table to internal table. Following tables i used in program :

Likp

Lips

VBPA

VBFA

A609

A555

A602.....etc.

Re: Reports executing very slow

Former Member — Tue, 30 Sep 2008 04:27:23 GMT

I think you are acesss the standard table the header and the Item

U should use lockobjects

and use enqueue and Dequeue Fucntion modules

but the table starting with A are customizing tables they can created by customizing itself so they are applicable only to a particular customer and they dont have any lock objects.

Regards

Devanand