topic Re: RE: performance issue in Application Development and Automation Discussions

RE: performance issue

Former Member — Thu, 07 Aug 2008 12:41:56 GMT

In my report I am written 10 select statements in a loop.

How can we avoid this?

can I replace with read statement?

Regards,

sampath .

Re: RE: performance issue

Former Member — Thu, 07 Aug 2008 12:43:51 GMT

You may increase the performance of select statements by how you write them, not how many you write.

-Pavan

Re: RE: performance issue

Former Member — Thu, 07 Aug 2008 12:44:42 GMT

Hi,

You have to aviod select inside a loop... AS FAR AS POSSIBLE...

Rather you use the loop and then read statement...

Also run the transaction ST05 and ST30 and check the difference after the change...

These help you to analyse the performance...

Regards

Re: RE: performance issue

ThomasZloch — Thu, 07 Aug 2008 12:46:14 GMT

hard to say based on the information provided.

If you select only few different values from buffered tables using the full primary key, then there is no problem.

If you select many different values from tables that are not buffered, you should consider reading all entries into sorted tables before the loop, then access the entries inside the loop using read statement.

Thomas

Re: RE: performance issue

Former Member — Thu, 07 Aug 2008 12:56:14 GMT

Hi sampath,

It s better to avoid select statements inside the loop.

Instead select the data using FOR ALL ENTRIES and then read them using READ TABLE statement.

Regards,

Prem

Edited by: Prem Karthick on Aug 7, 2008 2:56 PM

Re: RE: performance issue

Former Member — Thu, 07 Aug 2008 13:35:50 GMT

Hi Sampath,

First write all the select statements outside the loop and define a relationship between those tables, such that there should be a link between all those tables and then loop the item table.

Then read the internal tables inside the loop by using read statement with the fileds having proper relationship.

Hope this helps,

Regards,

Vijay

Re: RE: performance issue

Former Member — Fri, 08 Aug 2008 07:37:02 GMT

actually Thomas is right,

first you should check which tables are buffered! You should not remove select single on buffered tables from a loop.

Because the FOR ALL ENTRIES will not use the buffer (for single record buffers)

You should remove the select on unbuffered tables, and use FOR ALL ENTRIES into SORTED TABLES and use a read with key inside the loop.

But as allways, run traces first, maybe you actual performance problem is somewhere else!

Siegfried