ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anindya Mukherjee" <anindya.mukher...@gmail.com>
Subject RE: Force cache refresh + precaching
Date Thu, 16 Jul 2009 16:59:11 GMT
Ok got it.. Makes sense actually.. So looks like the only way to precache is running all the
possible queries ( that I expect ) during app load. 

 

-          Anindya

 

From: Chris O'Connell [mailto:oconnell@gorillachicago.com] 
Sent: July-16-09 8:33 PM
To: user-java@ibatis.apache.org
Subject: Re: Force cache refresh + precaching

 

Since no one else has replied...  I think you are looking at the iBatis cache the wrong way.
 My understanding of the cache is that it doesn't cache data from a table, it caches the results
of queries.  Note that the code to refresh the cache takes the name of the query that you
want refreshed, not the name of a table that you want refreshed.

 

-- Chris

On Wed, Jul 15, 2009 at 11:34 PM, Anindya Mukherjee <anindya.mukherjee@gmail.com> wrote:

Hi all,

Thanks a lot for your replies. Actually our's is a web application that
makes a lot of AJAX calls to get this data. We want these call's to be as
fast as possible. A slight delay even for the first time might be an issue.

So we were thinking if there is a way to precache the whole table during app
start rather than having it on demand.

The problem with running the queries on app startup is , we have a lot of
data in the table. We could call the queries but that will be a lot of
call's. Also if the data changes we have to add/remove our queries. So if
there is a way of telling IBatis to precache the whole table it will be
really nice.

- Anindya

-----Original Message-----
From: Jeff Butler [mailto:jeffgbutler@gmail.com]
Sent: July-16-09 2:15 AM
To: user-java@ibatis.apache.org
Subject: Re: Force cache refresh + precaching

Why not just execute the query in some startup process, this would
prime the cache?  In a web app you could do it in a context listener.
Easy.


Jeff Butler

On Wed, Jul 15, 2009 at 3:34 PM, Sundar Sankar<fatboysuns@gmail.com> wrote:
> I havent implemented this particular case, but I wud have to suggest you
go
> with other technologies in conjunction, maybe comet or something like
that.
> Am not sure if hibernate / hibernate cache handles this case but i wud
look
> to check up with their dev team too.
>
> On Wed, Jul 15, 2009 at 1:25 PM, Vinaya Tirikkovalluru
> <vinaya.tirikkovalluru@converge.com> wrote:
>>
>> Is there a specific reason why do you want to do that?
>>
>> Because, the first time you access the object, it will be created and
>> stored in cache
>>
>>
>>
>>
>>
>>
>>
>> ________________________________
>>
>> From: Anindya Mukherjee [mailto:anindya.mukherjee@gmail.com]
>> Sent: Wednesday, July 15, 2009 3:28 PM
>>
>> To: user-java@ibatis.apache.org
>> Subject: RE: Force cache refresh + precaching
>>
>>
>>
>> Hi Vinaya,
>>
>>
>>
>> Thanks a lot for the help. I actually meant during app load ( when our
>> application is booting ).
>>
>>
>>
>> -          Anindya
>>
>>
>>
>> From: Vinaya Tirikkovalluru [mailto:vinaya.tirikkovalluru@converge.com]
>> Sent: July-16-09 12:41 AM
>> To: user-java@ibatis.apache.org
>> Subject: RE: Force cache refresh + precaching
>>
>>
>>
>> Hi,
>>
>>
>>
>> What do you mean by before app load?
>>
>>
>>
>> To forcefully refresh the cache, you can use
>>
>>
>>
>> getSqlMapClient().flushDataCache("sqlmap.queryname");
>>
>>
>>
>> Vinaya
>>
>>
>>
>> ________________________________
>>
>> From: Anindya Mukherjee [mailto:anindya.mukherjee@gmail.com]
>> Sent: Wednesday, July 15, 2009 3:06 PM
>> To: user-java@ibatis.apache.org
>> Cc: anindya.mukherjee@gmail.com
>> Subject: Force cache refresh + precaching
>>
>>
>>
>> Hi ,
>>
>>
>>
>> We have started using iBatis caches. To start with we are using an LRU
>> cache. However we have an issue ,  the underlying tables in our db can be
>> updated by manual inserts ( it is a shared db used by a number of apps ).
>>
>>
>>
>> Now we need a mechanism whereby we can forcefully refresh the iBatis
>> cache. Can anybody help us with this ? Also the ibatis caches are lazy
>> loading ( it loads on demand ) , is it possible to somehow precache some
>> data during app load.
>>
>>
>>
>> -          Thanks,
>>
>> -          Anindya
>>
>> ________________________________
>>
>> 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.
>>
>> ________________________________
>> 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.
>
>
> --
> Regards
> Sundar S.
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org




-- 
-- 
Chris O'Connell
Application Developer
Gorilla
312.243.8777 x19


Mime
View raw message