Print Thread
Optimize = False
#44007 05/30/12 11:53 AM
Joined: Jul 2002
Posts: 71
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 71
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





Last edited by Ruudbern; 05/30/12 11:58 AM.
Re: Optimize = False
Ruudbern #44022 05/31/12 09:31 AM
Joined: Aug 1999
Posts: 22,207
Member
Offline
Member
Joined: Aug 1999
Posts: 22,207
You don't need to open the .dfm files, a recompile should be sufficient.


Marco Kalter
Allround Automations
Re: Optimize = False
Marco Kalter #44029 05/31/12 10:38 AM
Joined: Jul 2002
Posts: 71
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 71
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


Re: Optimize = False
Ruudbern #44033 06/01/12 10:19 AM
Joined: Aug 1999
Posts: 22,207
Member
Offline
Member
Joined: Aug 1999
Posts: 22,207
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.


Marco Kalter
Allround Automations
Re: Optimize = False
Marco Kalter #44062 06/10/12 06:34 PM
Joined: Jul 2002
Posts: 71
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 71
Hi Marco

Thnx for the info.



Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.020s Queries: 15 (0.005s) Memory: 2.5120 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-02 08:14:58 UTC
Valid HTML 5 and Valid CSS