topic Re: Performance issue in Application Development and Automation Discussions

Performance issue

Former Member — Wed, 25 Jul 2007 14:01:27 GMT

Hi,

I want to access the data from table BVOR, The only where clause which i m using is BUKRS, Its not fully specified Key, so thas why its taking a huge time for data retrieval for this select statement. How can I improve performance in this case. What if I use buffering for this table? What are the other solutions for performance improvement.

Thanks,

Re: Performance issue

Former Member — Thu, 26 Jul 2007 05:54:44 GMT

Please copy select statement and DDIC information of table, i.e. primary key and others, if there are any.

Check typical size of table, and try to get selectivity of the fields in your where condition.

I know that all this information can be checked in the system, but you should proviide it, if you expect a good answer.

Siegfried

Re: Performance issue

Former Member — Thu, 26 Jul 2007 07:10:48 GMT

Hi Sal Khan,

it is important to use as many key fields as possible in WHERE clause

in case if ur not sure about ur key fields then

Using the option GE (greater equal) in your coding to improve your performance considerably without the risk of table lines not being selected.

CONSTANTS: belnr_ini LIKE bvor-belnr VALUE IS INITIAL,

select ... from where belnr ge belnr_ini

and ... add all key fields.

and try to use select-options instead of parameters

Reward points if useful.

Regards

Cnu