topic Re: Optimized method in Application Development and Automation Discussions

Optimized method

Former Member — Tue, 12 Sep 2006 07:42:57 GMT

Hello all!

I am running a select on a TRDIR which is taking hell lot of time. Is there any other "optimized" way of doing it?

Puru

Re: Optimized method

Simha_ — Tue, 12 Sep 2006 07:46:28 GMT

Hi,

Use table REPOSRC instaead of that.

and it is also taking time..

create the indexess on the table..

This will solve ur problem..

Cheers,

Simha.

Re: Optimized method

Former Member — Tue, 12 Sep 2006 07:52:11 GMT

Hi,

can you show your select. and are you selecting all the entries or you have any specific conditions..

Regards

vijay

Re: Optimized method

Former Member — Tue, 12 Sep 2006 07:53:24 GMT

Hello Puru,

Use Sorted type internal tables.

If useful reward.

Vasanth

Re: Optimized method

Former Member — Tue, 12 Sep 2006 07:55:28 GMT

Hello Puru,

Create secondary indexes for the fields for which you are passing in the where clause. It will optimize the performance.

Thanks,

Krishnakumar

Re: Optimized method

anversha_s — Tue, 12 Sep 2006 07:59:43 GMT

hi,

some sugestions

************************

1. if u r using select * , avoid it. fetch the fields only u required.

2. give secondary index to the fields in the where clause.

3. after fetching into the internal tabel , sort the table.

4. avoid INTO CORESSPONDING in ur select query. it will take lot of time.

all the best.

if hlped rwrd points,

Rgds

anver

Re: Optimized method

Former Member — Tue, 12 Sep 2006 08:17:11 GMT

Hello Puru,

Use Sorted type internal tables.

If useful reward.

Vasanth