Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data Fetching Process is very slow in VA02

hi All,

When I am executing VA02 then it's taking too much time(8 to 10 minuts) during field selection and click on Scroll Bar for down.

I analyzed the trace(ST05) of VA02 and there is process of data fetching from table MCHB is very slow and in red high value. please have a look on following small portion of trace and guide me how can i manage this issue.

182 MCHB       PREPARE            0 SELECT WHERE "MANDT" = :A0 AND "MATNR" = :A1 AND "WERKS" = :A2
  1 MCHB       OPEN               0 SELECT WHERE "MANDT" = '600' AND "MATNR" = '000000500000000030' AND "WERKS" = '1000'
451 MCHB       FETCH     145      0
123,137 MCHB       FETCH     145      0
  180,671 MCHB       FETCH     145      0
  119,114 MCHB       FETCH     145      0
  126,028 MCHB       FETCH     145      0
  130,840 MCHB       FETCH     145      0
   90,472 MCHB       FETCH     145      0
   62,027 MCHB       FETCH     145      0
   98,619 MCHB       FETCH     145      0
  115,603 MCHB       FETCH     145      0
  156,984 MCHB       FETCH     145      0
  151,516 MCHB       FETCH     145      0
  113,686 MCHB       FETCH     145      0

Regards,

majamil

Former Member replied

Hi,

Please, don't feel offended.

That was not my intention.

I looked at the OP, you (I assume a different person) pointed to a thread (called "Note 830576 - Parameter recommendations for Oracle 10g") and I did not read that one as it is talking about PARAMETERS.

Sorry I did not read fully to the end and stopped on the first post.

But still, I think all my points are valid.

1.- small part of a trace

2.- 29 lines returning 145 rows each (for a total of 4205 rows)

3.- Still 1 ms per row

4.- Still a lot of row

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question