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:oconn...@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.mukher...@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:jeffgbut...@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<fatboys...@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.tirikkovall...@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.mukher...@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.tirikkovall...@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.mukher...@gmail.com] >> Sent: Wednesday, July 15, 2009 3:06 PM >> To: user-java@ibatis.apache.org >> Cc: anindya.mukher...@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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org -- -- Chris O'Connell Application Developer Gorilla 312.243.8777 x19
