topic Re: SMARTFORMS PRINT PREVIEW TAKING LONG TIME in Application Development and Automation Discussions

SMARTFORMS PRINT PREVIEW TAKING LONG TIME

former_member605939 — Wed, 11 Mar 2020 11:29:22 GMT

Developed the SF .But when we click on print preview button it is too long time to give output.

Does it due to select query ? or some parameter setting ?

Andreas-145 — Wed, 11 Mar 2020 11:39:23 GMT

The informations you gave are too small to give a perfect answer so:

Please start a SQL-Trace in Transaction ST05 and check database operations.

I think, you will find a slow query.

irfanjazz1 — Wed, 11 Mar 2020 11:39:39 GMT

check Your Driver Program..

trace query with st05..

former_member605939 — Wed, 11 Mar 2020 11:43:12 GMT

in addition to the post

Checked that the CALL FUNCTION 'SSFCOMP_PROCESS_DOCUMENT'

is taking too much time.

Abinathsiva — Wed, 11 Mar 2020 12:02:26 GMT

Hi,

If it's identified due to select query then share the code using code button.

RaymondGiuseppi — Wed, 11 Mar 2020 14:32:39 GMT

Run and analyze a trace of the execution

If it is already proven that the SQL query is the cause of the poor performance, perform a SQL trace (ST05)
Otherwise, perform an Abap trace (SAT, or ST12 if available).