Click here to Skip to main content
       

C#

 
GeneralRe: how to use subtract operation in windows form applicaion PinmemberShameel9-Oct-12 4:56 
AnswerRe: how to use subtract operation in windows form applicaion PinmemberEddy Vluggen9-Oct-12 2:46 
AnswerRe: how to use subtract operation in windows form applicaion PinmemberKiranKumar Roy14-Oct-12 1:47 
QuestionDatacache Pinmembernitin_ion9-Oct-12 0:25 
AnswerRe: Datacache PinprotectorPete O'Hanlon9-Oct-12 0:40 
GeneralRe: Datacache Pinmembernitin_ion9-Oct-12 17:15 
GeneralRe: Datacache PinprotectorPete O'Hanlon9-Oct-12 20:18 
GeneralRe: Datacache PinprotectorPete O'Hanlon9-Oct-12 22:01 
nitin_ion wrote:
Also is caching good?

You can't say definitively whether caching is good or not. It really depends on what you are using it for. If you just dumped all of the records in a large table in it and then had to post process it after you retrieved it from the cache just to find a couple of records, then you shouldn't use the cache. If you are using it to hold static lookup data then it's a fine choice.
 
As I said in my first answer, as you control updates/inserts and deletes in your DAL, I would use that to decide whether or not the cache needs to be refreshed. Just spitballing here, but one way to do this would be to have a CacheManager class in which you listed all the tables that have been cached (this data is a perfect candidate for storing in a database and holding in a cache) - then to each of your inserts, etc, simply call a TriggerRefresh method on the CacheManager. Simplistically, all it would need to do is empty that particular cached entry and then let your application lazy load the data on the next hit.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

GeneralRe: Datacache Pinmembernitin_ion9-Oct-12 23:15 
GeneralRe: Datacache PinprotectorPete O'Hanlon9-Oct-12 23:58 
QuestionGenereate XML file from sql in C# PinmemberMd. Rayhan Kabir8-Oct-12 18:17 
AnswerRe: Genereate XML file from sql in C# PinmemberSarath C8-Oct-12 22:42 
Questionhelp in solving a problem Pinmembermichae1108-Oct-12 6:24 
AnswerRe: help in solving a problem PinmvpRichard MacCutchan8-Oct-12 6:57 
AnswerRe: help in solving a problem PinmvpDave Kreskowiak8-Oct-12 11:00 
AnswerRe: help in solving a problem PinmvpAbhinav S8-Oct-12 17:37 
AnswerRe: help in solving a problem PinmemberPaul Conrad10-Oct-12 7:46 
QuestionUsing a datagridview to maintain SQL server database table PinmemberMember 80860588-Oct-12 1:35 
QuestionC# select part of file name Pinmemberclassy_dog7-Oct-12 16:00 
AnswerRe: C# select part of file name PinmvpAbhinav S7-Oct-12 17:47 
AnswerRe: C# select part of file name PinprotectorPete O'Hanlon7-Oct-12 20:17 
QuestionC# search for specific folder in directory Pinmemberclassy_dog7-Oct-12 10:19 
AnswerRe: C# search for specific folder in directory PinmemberRavi Bhavnani7-Oct-12 15:36 
Questioninvoke DoubleClick event Pinmemberjrahma7-Oct-12 9:03 
AnswerRe: invoke DoubleClick event PinmemberJF20157-Oct-12 9:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.141022.2 | Last Updated 24 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid