Click here to Skip to main content
15,921,716 members
Home / Discussions / C#
   

C#

 
GeneralRe: Hello Old Pros and Beginners… Pin
N8tiv17-Dec-11 22:10
N8tiv17-Dec-11 22:10 
GeneralRe: Hello Old Pros and Beginners… Pin
#realJSOP18-Dec-11 1:15
professional#realJSOP18-Dec-11 1:15 
GeneralRe: Hello Old Pros and Beginners… Pin
Pete O'Hanlon19-Dec-11 12:55
mvePete O'Hanlon19-Dec-11 12:55 
QuestionDBGhelp.dll read minidump Pin
Zach.Saunders17-Dec-11 9:04
Zach.Saunders17-Dec-11 9:04 
AnswerRe: DBGhelp.dll read minidump Pin
Eddy Vluggen18-Dec-11 1:40
professionalEddy Vluggen18-Dec-11 1:40 
QuestionText capture Pin
mmda17-Dec-11 4:47
mmda17-Dec-11 4:47 
AnswerRe: Text capture Pin
Luc Pattyn17-Dec-11 4:54
sitebuilderLuc Pattyn17-Dec-11 4:54 
QuestionPerformance issue with TableAdapter? Pin
MarkB12317-Dec-11 1:30
MarkB12317-Dec-11 1:30 
Hi,

I have a perceived performance issue doing a Fill on a Table Adapter...

The Sql Server Stored Procedure when executed on the SQL Server (which I have running on my development PC) takes around 3 seconds to complete returning approximately 6500 rows and 98 columns wide. When I run the same Stored Procedure with same parameters on my front-end c# app, and I do a TableAdapter.Fill(... it is taking around 36 seconds to populate the table adapter with the results of the Stored Procedure.
When it is rolled out to the live server, it can take over a minute resulting in a query timeout.

I realise this is a difficult thing to quantify, but does this sound excessive? Is there anything I can do to speed this up (obviously I could return less columns or rows but this is not really an option for me).

Often when I hook up the table adapter in a dataset in VS, it puts in column lengths for computed columns as quite small, eg string 12. I usually increase these to string 50 just in case I decide to adjust the SP with longer values for the computed columns in the future (so I don't need to rebuild the front end). Will this cause a hit on the front-end when populating?

Many thanks for taking the time to read this.
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 
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 

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.