Click here to Skip to main content
15,393,037 members
Home / Discussions / C#
   

C#

 
GeneralRe: how to use subtract operation in windows form applicaion Pin
Shameel9-Oct-12 4:56
professionalShameel9-Oct-12 4:56 
AnswerRe: how to use subtract operation in windows form applicaion Pin
Eddy Vluggen9-Oct-12 2:46
professionalEddy Vluggen9-Oct-12 2:46 
AnswerRe: how to use subtract operation in windows form applicaion Pin
KiranKumar Roy14-Oct-12 1:47
MemberKiranKumar Roy14-Oct-12 1:47 
QuestionDatacache Pin
nitin_ion9-Oct-12 0:25
Membernitin_ion9-Oct-12 0:25 
AnswerRe: Datacache Pin
Pete O'Hanlon9-Oct-12 0:40
mvaPete O'Hanlon9-Oct-12 0:40 
GeneralRe: Datacache Pin
nitin_ion9-Oct-12 17:15
Membernitin_ion9-Oct-12 17:15 
GeneralRe: Datacache Pin
Pete O'Hanlon9-Oct-12 20:18
mvaPete O'Hanlon9-Oct-12 20:18 
GeneralRe: Datacache Pin
Pete O'Hanlon9-Oct-12 22:01
mvaPete 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 Pin
nitin_ion9-Oct-12 23:15
Membernitin_ion9-Oct-12 23:15 
GeneralRe: Datacache Pin
Pete O'Hanlon9-Oct-12 23:58
mvaPete O'Hanlon9-Oct-12 23:58 
QuestionGenereate XML file from sql in C# Pin
Md. Rayhan Kabir8-Oct-12 18:17
MemberMd. Rayhan Kabir8-Oct-12 18:17 
AnswerRe: Genereate XML file from sql in C# Pin
Sarath C8-Oct-12 22:42
MemberSarath C8-Oct-12 22:42 
Questionhelp in solving a problem Pin
michae1108-Oct-12 6:24
Membermichae1108-Oct-12 6:24 
AnswerRe: help in solving a problem Pin
Richard MacCutchan8-Oct-12 6:57
mveRichard MacCutchan8-Oct-12 6:57 
AnswerRe: help in solving a problem Pin
Dave Kreskowiak8-Oct-12 11:00
mveDave Kreskowiak8-Oct-12 11:00 
AnswerRe: help in solving a problem Pin
Abhinav S8-Oct-12 17:37
MemberAbhinav S8-Oct-12 17:37 
AnswerRe: help in solving a problem Pin
Paul Conrad10-Oct-12 7:46
professionalPaul Conrad10-Oct-12 7:46 
QuestionUsing a datagridview to maintain SQL server database table Pin
Member 80860588-Oct-12 1:35
MemberMember 80860588-Oct-12 1:35 
QuestionC# select part of file name Pin
classy_dog7-Oct-12 16:00
Memberclassy_dog7-Oct-12 16:00 
AnswerRe: C# select part of file name Pin
Abhinav S7-Oct-12 17:47
MemberAbhinav S7-Oct-12 17:47 
AnswerRe: C# select part of file name Pin
Pete O'Hanlon7-Oct-12 20:17
mvaPete O'Hanlon7-Oct-12 20:17 
QuestionC# search for specific folder in directory Pin
classy_dog7-Oct-12 10:19
Memberclassy_dog7-Oct-12 10:19 
AnswerRe: C# search for specific folder in directory Pin
Ravi Bhavnani7-Oct-12 15:36
professionalRavi Bhavnani7-Oct-12 15:36 
Questioninvoke DoubleClick event Pin
Jassim Rahma7-Oct-12 9:03
MemberJassim Rahma7-Oct-12 9:03 
AnswerRe: invoke DoubleClick event Pin
JF20157-Oct-12 9:12
MemberJF20157-Oct-12 9: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.