Click here to Skip to main content
15,908,661 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to delete files and folders? Pin
Eddy Vluggen10-Oct-18 4:44
professionalEddy Vluggen10-Oct-18 4:44 
Questioncan't get these error code to go away Pin
Member 140081504-Oct-18 19:20
professionalMember 140081504-Oct-18 19:20 
AnswerRe: can't get these error code to go away Pin
OriginalGriff4-Oct-18 19:37
mveOriginalGriff4-Oct-18 19:37 
Questionpicboxes Pin
Ferdiinand4-Oct-18 10:31
Ferdiinand4-Oct-18 10:31 
AnswerRe: picboxes Pin
Mycroft Holmes4-Oct-18 12:52
professionalMycroft Holmes4-Oct-18 12:52 
GeneralRe: picboxes Pin
Ferdiinand4-Oct-18 13:11
Ferdiinand4-Oct-18 13:11 
AnswerRe: picboxes Pin
BillWoodruff14-Oct-18 15:16
professionalBillWoodruff14-Oct-18 15:16 
QuestionConversion from C to C#, Need C# Method Signature Pin
akvbsoft4-Oct-18 8:54
akvbsoft4-Oct-18 8:54 
AnswerRe: Conversion from C to C#, Need C# Method Signature Pin
Luc Pattyn4-Oct-18 16:23
sitebuilderLuc Pattyn4-Oct-18 16:23 
Rant[REPOST] Conversion from C to C#, Need C# Method Signature Pin
Richard Deeming5-Oct-18 1:45
mveRichard Deeming5-Oct-18 1:45 
QuestionHow to Cache a DB2 Dynamic Query in ADO.net Pin
kumarkoppireddy4-Oct-18 2:59
kumarkoppireddy4-Oct-18 2:59 
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 

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.