Posted By: Ruudbern Optimize = False - 05/30/12 11:53 AM
Hi,

we upgraded to a newer version of doa. I noticed that on all datasets the optimize property switches to false when a .dfm file has been changed.

it seems that this has a positive effect on some error's witch were hounting us.

Shoud we open and save all our dfm files?

regards Ruud




Posted By: Marco Kalter Re: Optimize = False - 05/31/12 09:31 AM
You don't need to open the .dfm files, a recompile should be sufficient.
Posted By: Ruudbern Re: Optimize = False - 05/31/12 10:38 AM
Hi Marco,

thnx for your answer but to me this seems strange. Although it is set to true in the dfm it wil be treated as false?

I now see that it is impossible to set it to true any more. It flips back to false.

This in combination with the treadsafe propety on the session seems to have a positive effect on "access violation in orageneric11.dll", "03106 Two task communication" and "ORA-01023 Cursor context not found" we were having at one site.

Can you give me some context/background info?

regards Ruud

Posted By: Marco Kalter Re: Optimize = False - 06/01/12 10:19 AM
The Optimize property would reuse the parsed representation of a cursor on the client. This way a SQL statement would only need to be parsed once when executed repeatedly. A bug in Oracle10g and later could cause problems when using this optimization, so this features is now suppressed.
Posted By: Ruudbern Re: Optimize = False - 06/10/12 06:34 PM
Hi Marco

Thnx for the info.

© Allround Automations forums