topic Re: Fetch data Quickly in Application Development and Automation Discussions

Fetch data Quickly

Former Member — Mon, 16 Apr 2007 11:03:07 GMT

Hi all,

Iam fetching data from CDHDR table. I have to get data for a given customer id

whose objectclas is 'DEBI'.

Iam trying to fetch the data but it takes a long time......

Can anyone suggest how to reduce this time, so that i can get the USERNAME, and UDATE details of a given customer quickly.

Thanks and Regards,

Anil.

Re: Fetch data Quickly

Former Member — Mon, 16 Apr 2007 11:07:10 GMT

U r doing correctly

SELECT USERNAME

UDATE

into table t_user

FROM CDHDR

WHERE OBJID EQ 'DEBI'

AND OBJECTCLAS eq w_customer.

But follow the DB order in WHERE as well as Retrieving

Tht's the only way....

Re: Fetch data Quickly

Former Member — Mon, 16 Apr 2007 11:07:29 GMT

Hi,

You need to pass these 3 parameters in the where condition

<b>Object class, Object value, Document change number</b>

Regards

Sudheer

Re: Fetch data Quickly

Former Member — Mon, 16 Apr 2007 11:08:41 GMT

Hi,

Its simple as this.. hope you know..

select <the fields you need> from CDHRD into <IT> where OBJECTCLAS = 'DEBI'.

Just check the number of entries in this table.. May be there are huge entries.. so its taking more time..

One thing I can say is Select the values from CDHRD using all the key of the table

Them it will take less time..

regards

nazeer,

Reward if useful

Message was edited by:

nazeer shaik

Re: Fetch data Quickly

Former Member — Mon, 16 Apr 2007 11:09:20 GMT

Hi,

Try to use the fun module

CHANGEDOCUMENT_READ_HEADERS

REWARD IF USEFUL

REGARDS,

ANJI

Re: Fetch data Quickly

Former Member — Mon, 16 Apr 2007 11:21:23 GMT

Hi anil,

I think u can fetech data(make a select statement ) using OBJECTCLAS(Object class),OBJECTID(Object value) make use of index . it might help u .

regards

Siva reddy