Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of odelya@jpost.com designates
 192.115.189.13 as permitted sender)
From: "Odelya YomTov" <odelya@jpost.com>
To: <user-java@ibatis.apache.org>
References: <007301ca5313$2edadda0$8c9098e0$@com>
	<011501ca5317$b09e5480$11dafd80$@com> <007501ca5318$548bd090$fda371b0$@com>
 <011701ca531a$c4adf3b0$4e09db10$@com>
In-Reply-To: <011701ca531a$c4adf3b0$4e09db10$@com>
Subject: RE: caching question
Date: Thu, 22 Oct 2009 15:25:54 +0200
Message-ID: <007901ca531b$2fddfc20$8f99f460$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcpTEyxILHbCF/VPTAqnf/0JhS3P5wABF5IwAAAtJjAAAE9/gAAAXWLQ
Content-Language: en-us

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-----
From: meindert [mailto:meindert@eduflex.com] 
Sent: Thursday, 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 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:odelya@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:meindert@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:odelya@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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org