Display archived documents takes a long time

[Former Member]

Dear Experts,

we are facing a strange problem. In transaction VF03 there is a possibility to display attached documents to an invoice. We have there the printentd and archived invoices as a PDF document attached. Now the problem...

...sometimes when the user want to see the archived documents it works within seconds, sometimes it takes a long time. After a first analyziz I think that if the document is displayed the first time it takes longer (but I am not sure). Does anybody of you now how SAP handles such files? Are they somewhere in a kind of a cache or buffer? Can the access be improved?

Thank you for your help.

Regards,

Milan

[markus_doehr2]

I would try the following:

- start transaction VF03

- open a second mode, start transaction ST05 and enable the SQL trace

- now open the document (execute no other transaction)

- if the document is displayed stop the SQL trace and check which table access is running so long

The problem may be indeed a cache displacement. On the first access the system must do a lot of I/O to read the document IDs, all further accesses are faster since the data is already in the database cache until other data replaces it.

Markus