performance in smart forms

[Former Member]

hi all,

when i execute smart form in production system it is taking more time to execute. But in development it is working fine.

please help me on this issue

thanking u

narendra

[Former Member]

thanks

[former_member196280]

It is nothing to do with your smartform, there might be lot of business data existing inside your production system. try to tune your data base queries. It will solve your problem.

regards,

SaiRam

[Former Member]

Hi,

This is a performance related issue. You could have search for various performance enhacement techniques.

Use SQL trace ST05 transaction to determine which sql query is taking time to execute and then try to optimize tht statement.

Please write if you need help about this or any other issue related to this.

Thanks,

Kartavya

[Former Member]

Most probably the heavier databases are to blame. Is there any chance of preparing the data in internal tables before excecuting the smartform?