topic Re: Coding in smartform \ Print Program in Application Development and Automation Discussions

Coding in smartform \ Print Program

Former Member — Mon, 04 May 2009 16:16:01 GMT

Hi,

Coding in smartforms is performence wise good or bad?

If good..how? If bad..how?

Pls guide me on this. I have spent a day on this to analyize!!

Regards,

Babs

Re: Coding in smartform \ Print Program

Former Member — Mon, 04 May 2009 16:36:42 GMT

We should avoid coding as much as posible inside smartforms.

This will increse the database load.

Fo eg., we havae a print program which is retreiving certain data from some tables. Then it will call the smartform. If you have some data retreival code in smartforms, again the system will access the DB. This will have a performance issue.

So we should try to access all the data bases before calling the SF. But for some exceptional cases (when modifying STD forms) we can't avoid this also.

Re: Coding in smartform \ Print Program

Former Member — Mon, 04 May 2009 16:51:36 GMT

Hi,

If the Smartform and Print program need's to be new created then incorporate all the logic in the print program instead of having in the smartform.

If your requirement is not to change the print program than there is no other way go..need to code in smartform.

Performance wise it would be better to have most of the logic in print program.

Re: Coding in smartform \ Print Program

Former Member — Mon, 04 May 2009 17:12:27 GMT

In case ur print program doesnot have the data u require and u may want to put select in smartform then u can use selects inside the initialization of smartform without affecting the performance much.

Re: Coding in smartform \ Print Program

Former Member — Tue, 05 May 2009 04:08:58 GMT

Thanks All..

Regards

Babs