topic Re: selection from database tables in Application Development and Automation Discussions

selection from database tables

Former Member — Thu, 31 Aug 2006 14:39:21 GMT

Hi Experts,

In one program I'm selecting data from tables <b>VBAK, VBAP,VBRK,VBRP,LIKP,LIPS</b>. As the tables have huge data, it's taking forever to get the data into internal tables.

Could you please suggest me to better the performance.

Thnx much.

Re: selection from database tables

RichHeilman — Thu, 31 Aug 2006 14:40:29 GMT

Make sure that you are selecting data from the tables using the key fields, this will help in performance.

Regards,

Rich Heilman

Re: selection from database tables

Former Member — Thu, 31 Aug 2006 14:42:34 GMT

hi dev,

do not use select .. endselect statement and include all the key fields in your select statement.

instead of select .. endselect statement use

select * from <table> into table itab where < conditions)

Regards,

Santosh

Message was edited by: Santosh Kumar P

Re: selection from database tables

Former Member — Thu, 31 Aug 2006 14:43:41 GMT

Fetching data is not a problem from this tables.

The only care to be taken is that will using select use index in the where clause & fetch those columns which are required.

Also while joining tables join on the primary keys.

this process will sharply reduce performance issues.

Regards

kapil

Re: selection from database tables

Former Member — Thu, 31 Aug 2006 14:44:34 GMT

in the where clause of the select try to give all the key fields ,

do not use select in loop ..... endloop.

Re: selection from database tables

Former Member — Thu, 31 Aug 2006 15:01:04 GMT

Hard to say without actually seeing your code. Could you please post it?

Rob

Re: selection from database tables

Former Member — Thu, 31 Aug 2006 15:04:19 GMT

Thnx all.

Re: selection from database tables

Former Member — Thu, 31 Aug 2006 15:05:43 GMT

hi Dev,

If any of the above answers were helpful mark those answers and close the thread if your problem is solved..

Regards,

santosh