Re: caching question

unity.de/archives/86-Pagination-with-Apache-iBatis-SqlMa > ps.html > > > -Original Message- > From: Odelya YomTov [mailto:ode...@jpost.com] > Sent: 22 October 2009 03:26 PM > To: user-java@ibatis.apache.org > Subject: RE: caching question > > So if lets say th

RE: caching question

03:26 PM To: user-java@ibatis.apache.org Subject: RE: caching question So if lets say the result could return 200 records, and the cacheModel size is set for 100 - would it return only 100 results? Or the next time it would actually display only the 100 records and not 200? -Original Message

RE: caching question

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 resul

RE: caching question

, October 22, 2009 3:23 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? 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 ca

RE: caching question

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

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&#

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

caching question

Hi! I have a global question about caching. I have in my database around 80 recrods In cacheModel - what do you recommend as the size of the cacheModel? I am using the query almost in every screen. Thanks - To unsubscr

RE: Caching Question

find good explanation in Ibatis guide. Vinaya -Original Message- From: Warren Bell [mailto:warrenbe...@gmail.com] Sent: Thursday, September 17, 2009 1:52 PM To: user-java@ibatis.apache.org Subject: Caching Question When I use caching, does the result object stay cached for a ce

Caching Question

When I use caching, does the result object stay cached for a certain period of time, so when I call the same sqlMap it returns me the cached object instead of querying the db for it again? And can you point me to a good guide of caching in iBatis? Warren --

Data Caching Question

Hi, I have enabled FIFO caching for a table. The first time I retrieve records using a criteria, it stores them in the cache. The next time I use the criteria, I get the result from the cache. Then I modify those records - not through the data object that was returned to me by the cache though.

RE: Statement Caching Question

the pointers. Alistair. -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: 11 November 2008 13:30 To: user-java@ibatis.apache.org Subject: Re: Statement Caching Question If you commit every few hundred rows, it will probably work for you... >From a more practical

Re: Statement Caching Question

If you commit every few hundred rows, it will probably work for you... >From a more practical perspective: If you are constructing all of the sql in java already, what's the point of using ibatis here? Why not just use straight JDBC for this one process? If you use the template approach that Sprin

RE: Statement Caching Question

> From: Nicholoz Koka Kiknadze [mailto:[EMAIL PROTECTED] > Sent: 11 November 2008 11:30 > To: user-java@ibatis.apache.org > Subject: Re: Statement Caching Question > >Or can somebody suggest another solution? > Maybe ask your DBA to increase max open cursors allowed? ;) :

Re: Statement Caching Question

>Or can somebody suggest another solution? Maybe ask your DBA to increase max open cursors allowed? ;) Honestly, I never quite understood iBATIS statement cacheing performance gains with oRACLE (which IMO maintains stetement cache on its own). Are you sure disabling it throughout your application

Statement Caching Question

Hello everybody. We have a big loop in which we're using iBATIS to insert many rows into a number of database tables. Unfortunately, for various pragmatic reasons, the underlying SQL map is using the $ notation for substitution. So it's something fairly unpleasant like: INSERT INTO $table$ ($

Re: Caching question

The answer to that question and your previous one are both in the iBATIS SqlMaps PDF on page 42: http://svn.apache.org/repos/asf/ibatis/trunk/java/docs/en/iBATIS-SqlMaps-2_e n.pdf Cheers, topher On 8/9/07 6:26 AM, "avalerio" <[EMAIL PROTECTED]> wrote: > > Thanks for the reply, one more questi

Re: Caching question

>> Now here's the question: Do I have to flush the cache myself after an >> update >> to a table? If I query a table that returns 4 rows then add or delete a >> row, >> when I query the table after the update I get the same 4 rows returned >> initially. >

Re: Caching question

row, >> when I query the table after the update I get the same 4 rows returned >> initially. >> Thanks. > > > -- View this message in context: http://www.nabble.com/Caching-question-tf4238620.html#a12071076 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: Caching question

You can use the: To automatically flush a specific cache when a specific query is run. Cheers, Chris On 8/8/07 1:44 PM, "avalerio1" <[EMAIL PROTECTED]> wrote: > > I've implemented the LRU caching model here's the config: > > > > > Now here's the question: Do I have to flush the cache

Caching question

table after the update I get the same 4 rows returned initially. Thanks. -- View this message in context: http://www.nabble.com/Caching-question-tf4238620.html#a12060474 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: caching question

The subselect is still full functional select, I think it doesn't matter where it is called, I mean It should be so! To be sure ... You can switch logging on and see if it puts your object in the cache, If it does, it will log a message that your object is putted in the cache, and when you resele

caching question

If I apply a cache model to a SELECT function in my config, but don't call this function directly through my Java code - rather as a "subselect" through a resultMap, will the result of that subselect still be cached?