I think it creates a connection, but get the results from oracle cache
not the application cache.
I assume this because, I see the following statements in the log file
whenever the cache is accessed by the app
2009-10-22 09:31:30,594 [,] INFO [STDOUT] {conn-100075} Connection
2009-10-22 09:31:30,594 [,] INFO [STDOUT] Cache
'NECXADM_CACHE_OBJECT.generalCache': retrieved object 'ABC, Asset, CPU,
Commodity, Purchasing, Division ...'
I might be wrong. Does anybody else have any other thought?
Vinaya
-----Original Message-----
From: meindert [mailto:meind...@eduflex.com]
Sent: Thursday, October 22, 2009 9:23 AM
To: user-java@ibatis.apache.org
Subject: RE: caching question
>Do you mean that actually it invokes the database when I execute the
query?
No, only the first time, the next time you ask the same query with the
same
parameters it will get the resultset from the cache
The cache size is the number of different result sets are stored in the
cache.
So if you invoke the same query (with the same parameters) multiple
times it
only does one round trip.
This is handy for example if you have a query that is executed after a
logon. This same query is repeated every time a logon is done. So you
could
put the result in a server level variable or you use the ibatis cache.
Another example would be a grid in your application that is requested by
multiple users (as long if it is requested with similar parameters)
If you're result set size is 800000 records or if the query parameters
are
different for every screen, ibatis caching is not for you,
-----Original Message-----
From: Odelya YomTov [mailto:ode...@jpost.com]
Sent: 22 October 2009 03:05 PM
To: user-java@ibatis.apache.org
Subject: RE: caching question
Do you mean that actually it invokes the database when I execute the
query?
If so, what is the point of caching?
-----Original Message-----
From: meindert [mailto:meind...@eduflex.com]
Sent: Thursday, October 22, 2009 3:01 PM
To: user-java@ibatis.apache.org
Subject: RE: caching question
It's the result you cache not the query. How many different query result
would you like to cache
-----Original Message-----
From: Odelya YomTov [mailto:ode...@jpost.com]
Sent: 22 October 2009 02:29 PM
To: user-java@ibatis.apache.org
Subject: caching question
Hi!
I have a global question about caching.
I have in my database around 800000 recrods
In cacheModel - what do you recommend as the size of the cacheModel?
I am using the query almost in every screen.
Thanks
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.423 / Virus Database: 270.14.20/2444 - Release Date:
10/21/09
16:44:00
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
************************************************************************
****
********
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals &
computer
viruses.
************************************************************************
****
********
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.423 / Virus Database: 270.14.20/2444 - Release Date:
10/21/09
16:44:00
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
This electronic message is intended only for the use of the individual(s) or
entity(ies) named above and may contain information which is privileged and/or
confidential. If you are not the intended recipient, be aware that any
disclosure, copying, distribution, dissemination or use of the contents of this
message is prohibited. If you received this message in error, please notify
the sender immediately.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
