performance in smartforms

[Former Member]

Hi All,

in production system it is taking more time to get print priview and in development it is working fine. The thing is development database is oracle 9i and production is 10g.

[Former Member]

thanks

[Former Member]

HI Naren,

Can you let me know about the tables you used and their linkage so that i can help you if i can.

Also make sure that you have taken some of the precautions mentioned below.

1. Try to use DB Fetches at the Initialization tab

2. If any of the internal table data is not used in after some point of time, free that table.

3. While using FOR ALL ENTRIES , it is mandatory to check whether the parent table is initial or not.

[former_member196280]

Don't worry about the database, it all depends on how effectively you write your queries. Try to use performance analysis tools.(ST05) and tune your quries.

Note: Mostly, it depends on the number of records you have in development and number of records in production.

Regards,

SaiRam