Click here to Skip to main content
15,920,956 members
Home / Discussions / C#
   

C#

 
AnswerRe: Performance issue with TableAdapter? Pin
Dan Mos17-Dec-11 1:44
Dan Mos17-Dec-11 1:44 
GeneralRe: Performance issue with TableAdapter? Pin
MarkB12317-Dec-11 1:57
MarkB12317-Dec-11 1:57 
AnswerRe: Performance issue with TableAdapter? Pin
Dan Mos17-Dec-11 2:38
Dan Mos17-Dec-11 2:38 
GeneralRe: Performance issue with TableAdapter? Pin
MarkB12317-Dec-11 3:22
MarkB12317-Dec-11 3:22 
AnswerRe: Performance issue with TableAdapter? Pin
Dan Mos17-Dec-11 6:12
Dan Mos17-Dec-11 6:12 
GeneralRe: Performance issue with TableAdapter? Pin
PIEBALDconsult17-Dec-11 3:24
mvePIEBALDconsult17-Dec-11 3:24 
GeneralRe: Performance issue with TableAdapter? Pin
MarkB12317-Dec-11 9:01
MarkB12317-Dec-11 9:01 
AnswerRe: Performance issue with TableAdapter - Break through? Pin
MarkB12317-Dec-11 8:09
MarkB12317-Dec-11 8:09 
I have made a break through - If I remove the date filter from my where clause on the Stored Proc, the data loads in a under a second (down from 36+ seconds).

The where clause has the following in it...


WHERE (@FromDate IS NULL OR ISNULL(A.[CallOutDateTime], '2900-12-31') >= @FromDate)
AND ((@ToDate IS NULL OR @ToDate = '1900-01-01') OR ISNULL(A.[CallOutDateTime], '1900-01-01') <= @ToDate)


Any ideas on why this would be causing the problem, bearing in mind when I execute the stored proc in SQL Server and pass it the same parameters as my front-end passes it runs in a second also, regardless of if I have the dates in the where cluase)? Bearing this in mind, I know it's not an indexing issue.
GeneralRe: Performance issue with TableAdapter - Break through? Pin
MarkB12317-Dec-11 8:24
MarkB12317-Dec-11 8:24 
GeneralRe: Performance issue with TableAdapter - Break through? Pin
Dan Mos17-Dec-11 9:37
Dan Mos17-Dec-11 9:37 
GeneralRe: Performance issue with TableAdapter - Break through? Pin
BillWoodruff17-Dec-11 11:33
professionalBillWoodruff17-Dec-11 11:33 
GeneralRe: Performance issue with TableAdapter - Break through? Pin
MarkB12317-Dec-11 12:10
MarkB12317-Dec-11 12:10 
QuestionConvert Given string to If statment Pin
cacampa16-Dec-11 23:55
cacampa16-Dec-11 23:55 
GeneralRe: Convert Given string to If statment Pin
harold aptroot17-Dec-11 0:47
harold aptroot17-Dec-11 0:47 
GeneralRe: Convert Given string to If statment Pin
BillWoodruff17-Dec-11 1:52
professionalBillWoodruff17-Dec-11 1:52 
AnswerRe: Convert Given string to If statment Pin
Dan Mos17-Dec-11 0:50
Dan Mos17-Dec-11 0:50 
AnswerRe: Convert Given string to If statment Pin
Richard MacCutchan17-Dec-11 1:34
mveRichard MacCutchan17-Dec-11 1:34 
AnswerRe: Convert Given string to If statment Pin
BillWoodruff17-Dec-11 1:49
professionalBillWoodruff17-Dec-11 1:49 
AnswerRe: Convert Given string to If statment Pin
Manfred Rudolf Bihy17-Dec-11 2:23
professionalManfred Rudolf Bihy17-Dec-11 2:23 
GeneralRe: Convert Given string to If statment Pin
thatraja17-Dec-11 2:51
professionalthatraja17-Dec-11 2:51 
GeneralRe: Convert Given string to If statment Pin
Manfred Rudolf Bihy17-Dec-11 15:11
professionalManfred Rudolf Bihy17-Dec-11 15:11 
AnswerRe: Convert Given string to If statment Pin
AmitGajjar17-Dec-11 7:19
professionalAmitGajjar17-Dec-11 7:19 
Questionhelp Pin
kb.bolbol16-Dec-11 12:51
kb.bolbol16-Dec-11 12:51 
AnswerRe: help Pin
AspDotNetDev16-Dec-11 13:03
protectorAspDotNetDev16-Dec-11 13:03 
AnswerRe: help Pin
Not Active16-Dec-11 13:51
mentorNot Active16-Dec-11 13:51 

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.