topic performance issue during fetching data from cluster table in Application Development and Automation Discussions

performance issue during fetching data from cluster table

Former Member — Tue, 25 Sep 2007 05:35:27 GMT

Hi there,

Because of the below select stmt I am getting poor performance.

But in sql trace it is showing KOCLU not KONV table....plz update me here.

SELECT KNUMV KPOSN KSCHL KAWRT KWERT

INTO TABLE I_KONV

FROM KONV

WHERE KSCHL IN ('ZC00','ZS00','MWI2','R100') .

Plz also let me know the suggetions to improve performance..

Re: performance issue during fetching data from cluster table

Former Member — Tue, 25 Sep 2007 05:38:13 GMT

hi,

use innerjoin query it will get good performance

thanks,

reward points if helpful...

Re: performance issue during fetching data from cluster table

Former Member — Tue, 25 Sep 2007 05:38:41 GMT

Use buferring, which helps you to improve the performance.

U r using WHERE IN condition which is good.

Or beter u can the save 'ZC00','ZS00','MWI2','R100' these in an internal table,

and then u can use

<i>Select for all entries</i> which is comparitively good.

Please reward if helpful.

Re: performance issue during fetching data from cluster table

kiran_k8 — Tue, 25 Sep 2007 05:52:17 GMT

Tuborg,

KSCHL is neither a primary key nor an index.So obviously it will take time.

First get all the data irrespecitve the KSCHL you had mentioned,into an internal table and then filter the internal table with your requirement.

loop at ifinal.

IF NOT ( itfinal-kschl = 'ZC00' OR itfinal-KSCHL = 'ZS00' OR itfinal-KSChL = 'MW12' OR itfinal-KSCHL = 'R100' )

DELETE ITFINAL.

ENDLOOP.

K.Kiran.

Re: performance issue during fetching data from cluster table

Former Member — Tue, 25 Sep 2007 06:00:06 GMT

hi kiran,

I dont think that will give good performance. coz we are going to retreive all the table!

Re: performance issue during fetching data from cluster table

kiran_k8 — Tue, 25 Sep 2007 06:05:49 GMT

Tuborg,

Retrie all means whatever the data you want from the table not select *.

Always see to that you use only primary key fields or index fields to improve the performance.100% sure.

K.Kiran.

Re: performance issue during fetching data from cluster table

Former Member — Tue, 25 Sep 2007 06:14:11 GMT

Hi,

As you are getting the data from cluster table it will have the low performance. Just check if you can reduce your performance, or if you can increase the fields in WHERE clause.

Regards,

Atish