DevForce Community Forum : Expire Query Cache http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Expire Query Cache Sun, 12 Apr 2026 04:40:02 -700 Fri, 12 Mar 2010 10:03:02 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1679 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Expire Query Cache : In the Business Object Persistence... http://www.ideablade.com/forum/forum_posts.asp?TID=1679&PID=6353#6353 Author: GregD
Subject: 1679
Posted: 12-Mar-2010 at 10:03am

In the Business Object Persistence topic document, see the following sections:
  • Stale Entity Data
  • Query Workflow
  • Query Strategy
  • Fetch Strategies
  • Merge Strategies
In the Business Object Persistence - Advanced topic document, see:
  • Forced Re-Fetch
  • Merge Strategy in More Detail
 
There also is a Push Notification code sample, with accompany documentation, in the Learning Resources at
 
     LearningResources\050_BusObjServer\Samples\300WNF_ServerPushNotification
 
although, as I say, this facility is not currently available for Silverlight.
]]> Fri, 12 Mar 2010 10:03:02 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1679&PID=6353#6353 Expire Query Cache : Thanks for the reply. We are... http://www.ideablade.com/forum/forum_posts.asp?TID=1679&PID=6352#6352 Author: kpinniger
Subject: 1679
Posted: 12-Mar-2010 at 7:38am

Thanks for the reply. 
 
We are a SmartClient framework accessing a legacy ERP systems database.  Updates to the database can happen from many different sources outside of our SmartClient so we are needing the cache to periodically check to see if it has been updated.  So the Business Object Server requerying the database at a specific interval to determine if entities have changed is what we are looking for, are there any examples of this or a spot in the documentation that you can point me to to help me out.
 
Thanks,
Kurt
]]> Fri, 12 Mar 2010 07:38:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1679&PID=6352#6352 Expire Query Cache : Removal probably isn't what... http://www.ideablade.com/forum/forum_posts.asp?TID=1679&PID=6350#6350 Author: IdeaBlade
Subject: 1679
Posted: 11-Mar-2010 at 7:05pm

Removal probably isn't what you would want in any case, because plucking an Entity out of the cache when other things potentially have active references to it could cause many different kinds of disruption.

What might be desirable, on the other hand, would be to have the entities updated in place. That's exactly what we do when you retrieve copies of entities you already have in the cache (using EntityQueries, Refetch, navigation, or any other mechanism for data retrieval).  We make a number of different MergeStrategies available for doing this, but the default is that we will update the existing entity in the cache as long as it doesn't have unsaved changes.

We don't supply a setting on the EntityManager to do this automatically, but we do provide a number of mechanisms that permit you to accomplish what you want. In general it's good to be as specific as possible about what you really need refreshed, as it's not hard to impair performance if you're a bit too gratuitous in retrieving and re-retrieving data.

On platforms other than Silverlight, we have a push notification facility that allows you to invoke a method on the Business Object Server which then stays alive and does any operation you need, such as requerying the database at a specified interval, determining if any entities have changed, and then calling the client to let it know that they have. When we implemented push, the necessary infrastructure wasn't available in Silverlight. It now is, but we simply haven't gotten back around to push for that platform yet. It's on our list.

It's often not the best solution in any case. You (the developer) can generally figure out which entities go stale at what intervals, or in which parts of the application (and when the user does what) those entities need to be brought into currency. If you're writing on online ticket sales application, for example, you'd surely want to provide current data to the sales clerk about what seats remain unsold when she's talking with a customer. But you could give her a button to demand that when a customer inquires about a given event, for example.

So, lots of mechanisms. If you like, say more about your use case and perhaps we can suggest a specific strategy.
]]> Thu, 11 Mar 2010 19:05:02 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1679&PID=6350#6350 Expire Query Cache : Is there a setting on the EntityManager... http://www.ideablade.com/forum/forum_posts.asp?TID=1679&PID=6343#6343 Author: kpinniger
Subject: 1679
Posted: 10-Mar-2010 at 2:20pm

Is there a setting on the EntityManager to remove an Entity from the cache after x amount of time?  Basically we know that the data might change during the day and we would like the cache to get invalidated after say 30 minutes. 

Thanks,
Kurt Pinniger
CDC Software


Edited by kpinniger - 10-Mar-2010 at 2:21pm]]> Wed, 10 Mar 2010 14:20:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1679&PID=6343#6343