Print Thread
Using StatementCache, StatementCacheSize
#47846 09/15/13 03:14 PM
Joined: Sep 2013
Posts: 14
S
C
Member
OP Offline
Member
C
Joined: Sep 2013
Posts: 14
S
It is recommended to use StatementCache in what situation?
What is the value recommended for StatementCacheSize?
StatementCacheSize is the size in bytes or queries?

Re: Using StatementCache, StatementCacheSize
Consinco #47848 09/16/13 09:50 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
The StatementCacheSize property determines the maximum number of cached statements when the StatementCache is enabled for the session. The recommended value depends on your application.


Marco Kalter
Allround Automations
Re: Using StatementCache, StatementCacheSize
Consinco #63333 02/17/22 02:31 PM
Joined: Mar 2010
Posts: 14
H
Member
Offline
Member
H
Joined: Mar 2010
Posts: 14
For me it is still not clear how "StatementCache" works here and what it is used for.
Is it somehow related to TOracleDataset.cachedUpdates?
We have TOracleDataset.commitOnPost=true and TOracleDataset.CountAllRecords=true.
We see severe network performance degregation and now I would like to understand if "StatementCache" would do the trick that "StatementCacheSize" determines the number of records read in a chunk?
Or do we have to adjust all SQL-statements in the application to limit the amount of records to be read?

Re: Using StatementCache, StatementCacheSize
Consinco #63334 02/17/22 02:52 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
It is not related to CachedUpdates. It is an Oracle cache for parsed statements, which can reduce the number of parses for frequently used statements.


Marco Kalter
Allround Automations
Re: Using StatementCache, StatementCacheSize
Consinco #63335 02/17/22 02:53 PM
Joined: Mar 2010
Posts: 14
H
Member
Offline
Member
H
Joined: Mar 2010
Posts: 14
One more detail:
is "StatementCache" related to TOracleDataset.ReadBuffer?
(we have TOracleDataset.QueryAllRecords=false and TOracleDataset.ReadBuffer=25)

Which statements are cached with "StatementCache" and does that impact WHEN a post is committed?

Re: Using StatementCache, StatementCacheSize
Consinco #63336 02/17/22 03:01 PM
Joined: Mar 2010
Posts: 14
H
Member
Offline
Member
H
Joined: Mar 2010
Posts: 14
Sorry - finally found it explained in the DOA documentation.
"StatementCache" determines if Oracle does cache the statements on the server and thus impacts performance on repeated statements as long as these are in the cache.

Re: Using StatementCache, StatementCacheSize
Consinco #63377 02/19/22 11:49 AM
Joined: Mar 2010
Posts: 14
H
Member
Offline
Member
H
Joined: Mar 2010
Posts: 14
Does a change of "StatementCache" require to disconnect and connect again - or can we change this for an active session?

Re: Using StatementCache, StatementCacheSize
Consinco #63378 02/19/22 01:04 PM
Joined: Mar 2010
Posts: 14
H
Member
Offline
Member
H
Joined: Mar 2010
Posts: 14
Tried to change this during active session: that is rejected with a message that this cannot be done when connected.


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.041s Queries: 15 (0.007s) Memory: 2.5263 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-28 09:41:10 UTC
Valid HTML 5 and Valid CSS