Click here to Skip to main content
15,897,704 members
Home / Discussions / C#
   

C#

 
AnswerRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
OriginalGriff4-Oct-18 3:14
mveOriginalGriff4-Oct-18 3:14 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
kumarkoppireddy4-Oct-18 3:50
kumarkoppireddy4-Oct-18 3:50 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
OriginalGriff4-Oct-18 3:54
mveOriginalGriff4-Oct-18 3:54 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
kumarkoppireddy4-Oct-18 4:13
kumarkoppireddy4-Oct-18 4:13 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
Dave Kreskowiak4-Oct-18 4:27
mveDave Kreskowiak4-Oct-18 4:27 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
kumarkoppireddy4-Oct-18 4:54
kumarkoppireddy4-Oct-18 4:54 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
Dave Kreskowiak4-Oct-18 5:04
mveDave Kreskowiak4-Oct-18 5:04 
AnswerRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
Gerry Schmitz4-Oct-18 5:10
mveGerry Schmitz4-Oct-18 5:10 
1.) What makes you think there's a problem? (Your "example" looks like it will retrieve only one record from a "trivial" database of 900K records). All queries have a "first time" cost due to server data paging that is reduced for subsequent queries hitting the same pages.

2.) What are the the odds that 2 people are running the exact same query at the same time?

3.) How do you insure you are not caching and then returning "stale data"?

(Think hard about the consequences of #3)
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
kumarkoppireddy4-Oct-18 5:52
kumarkoppireddy4-Oct-18 5:52 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
Dave Kreskowiak4-Oct-18 6:22
mveDave Kreskowiak4-Oct-18 6:22 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
kumarkoppireddy4-Oct-18 6:25
kumarkoppireddy4-Oct-18 6:25 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
Dave Kreskowiak4-Oct-18 6:46
mveDave Kreskowiak4-Oct-18 6:46 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
OriginalGriff4-Oct-18 6:32
mveOriginalGriff4-Oct-18 6:32 
GeneralRe: How to Cache a DB2 Dynamic Query in ADO.net Pin
Mycroft Holmes4-Oct-18 12:48
professionalMycroft Holmes4-Oct-18 12:48 
Questiondisplay value of a key in dictionary to text box and edit value and save out to file Pin
elfenliedtopfan53-Oct-18 14:02
elfenliedtopfan53-Oct-18 14:02 
AnswerRe: display value of a key in dictionary to text box and edit value and save out to file Pin
Maciej Los3-Oct-18 20:28
mveMaciej Los3-Oct-18 20:28 
AnswerRe: display value of a key in dictionary to text box and edit value and save out to file Pin
OriginalGriff3-Oct-18 20:35
mveOriginalGriff3-Oct-18 20:35 
AnswerRe: display value of a key in dictionary to text box and edit value and save out to file Pin
dan!sh 3-Oct-18 20:36
professional dan!sh 3-Oct-18 20:36 
AnswerRe: display value of a key in dictionary to text box and edit value and save out to file Pin
BillWoodruff14-Oct-18 15:21
professionalBillWoodruff14-Oct-18 15:21 
QuestionOPC client server Pin
Roberto64_Ge3-Oct-18 2:28
Roberto64_Ge3-Oct-18 2:28 
AnswerRe: OPC client server Pin
Richard MacCutchan3-Oct-18 3:11
mveRichard MacCutchan3-Oct-18 3:11 
GeneralRe: OPC client server Pin
Roberto64_Ge3-Oct-18 4:10
Roberto64_Ge3-Oct-18 4:10 
GeneralRe: OPC client server Pin
Richard MacCutchan3-Oct-18 4:52
mveRichard MacCutchan3-Oct-18 4:52 
GeneralRe: OPC client server Pin
Roberto64_Ge3-Oct-18 9:51
Roberto64_Ge3-Oct-18 9:51 
GeneralRe: OPC client server Pin
Richard MacCutchan3-Oct-18 22:02
mveRichard MacCutchan3-Oct-18 22:02 

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.