topic Re: select data from database tables with high performance in Application Development and Automation Discussions

select data from database tables with high performance

Former Member — Sat, 08 Mar 2008 08:01:02 GMT

hi all,

how to select data from different database tables with high performance.

im using for all entries instead of inner joins, even though burden on data base tables is going very high ( 90 % in se30)

hw to increase the performance.

kindly, reply.

thnks

Former Member — Sat, 08 Mar 2008 08:14:54 GMT

Hi,

I think may be large amount of data vl b the problem for tht.

U can run tht one in back ground also

U can use secondary index concept in select query.

Use secondary index on fields wher u used in where condition part of select query.

I think it vl reduce.

Thanks & Regards,

R.P.Sastry

Former Member — Sat, 08 Mar 2008 08:26:51 GMT

Hi,

Check if you are selecting the required data only.

Rectify the where clause .

You can use the selection by primary key filds if possible.

if records are in millions then go for secondary indexes.

Former Member — Sat, 08 Mar 2008 08:29:49 GMT

Also Check you are not using open sql much like distict order by group by , use abap techniques on internal table to acive the same.

also Dont use select endselect.

if possible use up to n rows claus....

taht will limit the data base hits.

also dont run select in siode any loops.

i guess these are some of the trics oyu can use to avoid frequent DATA BASE HITS AND ABVOID THE DATA BASE LAOD.

Former Member — Sat, 08 Mar 2008 08:57:06 GMT

hi,

do like this....

1. select all keys for the selection criteria , because if some cases we generally doesnt use all the keys but it is very important.

2. sort table with binary search is must.

3. get the required fields only and not all the fields for selection with higher structure.

4 . avoid looping in side the select .

5. use select upto 1 row rather than select single.

it may be useful ,

regards,

venkat.