topic Re: Performance Issue - Update response time in Application Development and Automation Discussions

Performance Issue - Update response time

Former Member — Wed, 24 Jan 2007 17:26:41 GMT

Hi,

I am trying to get the equipment data and I have to link with asset. The only way I could find is through m_equia view. I select the equipment number from m_equia passing the key as asset no and from there i go to equi and get the other data.

But when i am trying to select from m_equia the database time is more. So, can some one suggest me a better option for this other than the m_equia to get the equipment details with asset as the key. I also have cost center details with me.

Thanks,

Re: Performance Issue - Update response time

Former Member — Wed, 24 Jan 2007 17:41:27 GMT

u need to create an index on the table..so that database access will be fast.

Re: Performance Issue - Update response time

Former Member — Wed, 24 Jan 2007 17:46:00 GMT

I am pushing everything to Ztable. Do you mean I have to create an index on Ztable ? Can you explain more in detail.

Thanks in advance.

Message was edited by:

lakshmi

Re: Performance Issue - Update response time

Former Member — Wed, 24 Jan 2007 18:58:39 GMT

Hi,

Try using FM 'AAPM_AA_READ_EQUIS_OF_ASSET'. You pass the Company code, Asset # & Sub Asset #. In return, you'll get the equipments linked to it.

Regards

Shantharam

Re: Performance Issue - Update response time

RichHeilman — Wed, 24 Jan 2007 19:04:45 GMT

I'm sure is referring to putting an index on m_equia, but this is a view of multiple tables, so you would have to decide which tables to index on. First lets examine your select statement. Can you please post the select statement for m_equia,.

Regards,

Rich Heilman

Re: Performance Issue - Update response time

Former Member — Wed, 24 Jan 2007 19:13:17 GMT

Hi,

Please find the select on m_equia and further select on it.

Get asset related data from the view

IF NOT i_asset[] IS INITIAL.
SELECT anlnr
equnr
FROM m_equia
INTO TABLE i_asst_equi
FOR ALL ENTRIES IN i_asset
WHERE anlnr = i_asset-anln1 AND
anlun = i_asset-anln2 AND
bukrs = i_asset-bukrs.
IF sy-subrc = 0.
SORT i_asst_equi BY equnr.
ENDIF.
ENDIF.

Get Equipment related data

IF NOT i_asst_equi[] IS INITIAL.
SELECT equi~equnr
herst
typbz
eqart
mapar
serge
iwerk
FROM equi
INNER JOIN equz
ON equi_{equnr = equz}equnr
INTO TABLE i_equipment
FOR ALL ENTRIES IN i_asst_equi
WHERE equi~equnr = i_asst_equi-equnr.
SORT i_equipment BY equnr.
ENDIF.

Thanks.

Message was edited by:

lakshmi

Re: Performance Issue - Update response time

RichHeilman — Wed, 24 Jan 2007 19:19:31 GMT

First lets try sorting the table.

** Get asset related data from the view
 IF NOT i_asset[] IS INITIAL.

<b>

sort i_asset ascending by anln1 anln2 bukrs

.</b>

 SELECT anlnr equnr
           FROM m_equia
               INTO TABLE i_asst_equi
                       FOR ALL ENTRIES IN i_asset
                                WHERE anlnr = i_asset-anln1 AND
                                             anlun = i_asset-anln2 AND
                                             bukrs = i_asset-bukrs.
     IF sy-subrc = 0.
      SORT i_asst_equi BY equnr.
     ENDIF.
 ENDIF.

Regards,

Rich Heilman

Re: Performance Issue - Update response time

Former Member — Wed, 24 Jan 2007 19:26:26 GMT

Hi Rich,

This is how i am using the select now....do you think i should sort ascending ?

Select all the Asset/Kiosk Nos.

SELECT bukrs

anln1

anln2

anlkl

erdat

aedat

xloev

xspeb

ktogr

zujhr

zuper

aktiv

ivdat

txt50

FROM anla

INTO TABLE i_asset

where ANLKL = '00002000'.

IF sy-subrc = 0.

SORT i_asset BY anln1.

ENDIF.

Thanks.

Message was edited by:

lakshmi

Re: Performance Issue - Update response time

Former Member — Wed, 24 Jan 2007 19:30:54 GMT

Try selecting ILOA-ILOAN using your asset number (secondary index).

Then SELECT EQUUZ-EQUNR using ILOAN (also secondary index).

You can get whatever else you need using asset and equipment numbers.

Rob

Re: Performance Issue - Update response time

Former Member — Wed, 24 Jan 2007 19:38:50 GMT

Can i do an inner join on ILOA & EQUZ by any chance (Also how do i know if its a secondary index or ..) ?

Message was edited by:

lakshmi

Re: Performance Issue - Update response time

Former Member — Wed, 24 Jan 2007 19:54:43 GMT

M_EQUIA includes a join of ILOA and EQUUZ, so yes you can do your own join.

Click on the "Indexes" button in the data dictionary to see the secondary indexes of any table.

rob

Re: Performance Issue - Update response time

ferry_lianto — Wed, 24 Jan 2007 19:55:03 GMT

Hi,

Can i do an inner join on ILOA & EQUZ?

Please try this.

SELECT ....

INTO ....

FROM ILOA as a inner join EQUZ as b on b_{ILOAN = a}ILOAN

WHERE ...

Regards,

Ferry Lianto