asp.net - LINQ driven cache items invalidation -


i'm making asp.net mvc project , implement business data caching @ repository (linq2sql) layer. since entities related each other, need invalidate related ones when i'm invalidating base entity. have blog/post/comments relation , when user makes new comment need invalidate cached post entity since has outdated totalcomments field. there more complicated logic invalidation other entities.
well, need implement flexible invalidation mechanism purpose. i've found before:
- sql notifications service. notifies app each time table has changed. since i'll have high-loaded application, changes on tables gonna often. cached comments post drop each time new comment added.
- caching linq(or sql) queries. in case rendered query placed cache using hash key. not bad impossible drop "all comment entities having blogpostid = deletedblogpostid"

and idea is. wanna use linq queries on httpruntime.cache items find items deleted properties (e.g. in case of deleting blog post 

cacheditem => cacheditem.gettype() == typeof(comment)         && ((comment)cacheditem).blogpostid == deletedblogpostid

to delete related comments). can't find in google approach used. isn't way manipulate cached related entities? query performance on 1m cached items 600 ms on notebook.
thanks!

i call cache clearing method in controller corresponding object. example, if user editing individual post, in controller method handles post request should clear cache post.

using sql server notification services seems backwards me. server-side web application first point of entry users; database comes after. know when need clear cache in mvc application, why not clear cache there?

edit:

one other option storing data in cache , having access via key (so don't have iterate on entire cache collection):

httpruntime.cache.insert(string.format("commentsforpost-{0}", postid), value);

where value list<comment> , postid id of post. way comment collection , cache keys dynamic. i've used approach across many applications (though write more generic less code duplication).


Comments

Post a Comment

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more

php - Controller/JToolBar not working in Joomla 2.5 -

relevant code: jtoolbarhelper::custom('savecategories', 'save', '', 'save', false, false); ... <input type="hidden" name="controller" value="easyblogcontroller"> according can dig docs , own previous questions, should call savecategories() function in easyblogcontroller . i've tried setting value easyblog , easyblog.php (file name) current easyblogcontroller (class name). clicking on save button refreshes page. not redirect, echo or var_dump test code put in savecategories() function. var_dump ing jrequest::getvar('controller') , 'task' return correct values. creating controller object , using $controller->execute('task'); works. the values going depend on location of controller trying call, , have couple options here. typically there controller in base folder of component (likely components/com_easyblog) in file called controller.php , class name inside ...
Read more