Entries from June 1, 2007 - July 1, 2007
Increase WorkflowGen's performances with Oracle database
WFG Team
Post a Comment
To dramatically increase WorkflowGen database performance you have to check your database optimizer mode.
If the optimizer_mode is set to CHOOSE (by default in Oracle 9i an 10g), you have to frequently (weekly by example) "ANALYZE" all the tables of your databases. This operation will generate statistics used by the optimizer to select the best mode (RULE instead of all_rows) to run a SQL query.
Another solution is to set the optimizer_mode to RULE.
If the optimizer_mode is set to CHOOSE (by default in Oracle 9i an 10g), you have to frequently (weekly by example) "ANALYZE" all the tables of your databases. This operation will generate statistics used by the optimizer to select the best mode (RULE instead of all_rows) to run a SQL query.
Another solution is to set the optimizer_mode to RULE.
How to return the user to the same position in the client browser after postback.
When the MaintainScrollPositionOnPostback property (or page directive) is set to true, the user is instead returned to the last position on the page.
RSS