Coding in smartform \ Print Program

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

Thanks All..

Regards

Babs