Click here to Skip to main content
12,622,032 members (36,150 online)
   

C#

 
GeneralRe: how to use subtract operation in windows form applicaion Pin
Shameel9-Oct-12 5:56
memberShameel9-Oct-12 5:56 
AnswerRe: how to use subtract operation in windows form applicaion Pin
Eddy Vluggen9-Oct-12 3:46
memberEddy Vluggen9-Oct-12 3:46 
AnswerRe: how to use subtract operation in windows form applicaion Pin
KiranKumar Roy14-Oct-12 2:47
memberKiranKumar Roy14-Oct-12 2:47 
QuestionDatacache Pin
nitin_ion9-Oct-12 1:25
membernitin_ion9-Oct-12 1:25 
AnswerRe: Datacache Pin
Pete O'Hanlon9-Oct-12 1:40
protectorPete O'Hanlon9-Oct-12 1:40 
GeneralRe: Datacache Pin
nitin_ion9-Oct-12 18:15
membernitin_ion9-Oct-12 18:15 
GeneralRe: Datacache Pin
Pete O'Hanlon9-Oct-12 21:18
protectorPete O'Hanlon9-Oct-12 21:18 
GeneralRe: Datacache Pin
Pete O'Hanlon9-Oct-12 23:01
protectorPete O'Hanlon9-Oct-12 23: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 Pin
nitin_ion10-Oct-12 0:15
membernitin_ion10-Oct-12 0:15 
GeneralRe: Datacache Pin
Pete O'Hanlon10-Oct-12 0:58
protectorPete O'Hanlon10-Oct-12 0:58 
QuestionGenereate XML file from sql in C# Pin
Md. Rayhan Kabir8-Oct-12 19:17
memberMd. Rayhan Kabir8-Oct-12 19:17 
AnswerRe: Genereate XML file from sql in C# Pin
Sarath C8-Oct-12 23:42
memberSarath C8-Oct-12 23:42 
Questionhelp in solving a problem Pin
michae1108-Oct-12 7:24
membermichae1108-Oct-12 7:24 
AnswerRe: help in solving a problem Pin
Richard MacCutchan8-Oct-12 7:57
mvpRichard MacCutchan8-Oct-12 7:57 
AnswerRe: help in solving a problem Pin
Dave Kreskowiak8-Oct-12 12:00
mvpDave Kreskowiak8-Oct-12 12:00 
AnswerRe: help in solving a problem Pin
Abhinav S8-Oct-12 18:37
mvpAbhinav S8-Oct-12 18:37 
AnswerRe: help in solving a problem Pin
Paul Conrad10-Oct-12 8:46
memberPaul Conrad10-Oct-12 8:46 
QuestionUsing a datagridview to maintain SQL server database table Pin
Member 80860588-Oct-12 2:35
memberMember 80860588-Oct-12 2:35 
QuestionC# select part of file name Pin
classy_dog7-Oct-12 17:00
memberclassy_dog7-Oct-12 17:00 
AnswerRe: C# select part of file name Pin
Abhinav S7-Oct-12 18:47
mvpAbhinav S7-Oct-12 18:47 
AnswerRe: C# select part of file name Pin
Pete O'Hanlon7-Oct-12 21:17
protectorPete O'Hanlon7-Oct-12 21:17 
QuestionC# search for specific folder in directory Pin
classy_dog7-Oct-12 11:19
memberclassy_dog7-Oct-12 11:19 
AnswerRe: C# search for specific folder in directory Pin
Ravi Bhavnani7-Oct-12 16:36
memberRavi Bhavnani7-Oct-12 16:36 
Questioninvoke DoubleClick event Pin
jrahma7-Oct-12 10:03
memberjrahma7-Oct-12 10:03 
AnswerRe: invoke DoubleClick event Pin
JF20157-Oct-12 10:12
memberJF20157-Oct-12 10:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.161128.1 | Last Updated 2 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid