Click here to Skip to main content
15,891,607 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionImage from camera is not refreshed in Internet Exlporer Pin
kjsl2k915-Jan-10 0:47
kjsl2k915-Jan-10 0:47 
Questionhow to convert dataset to excel retaining page loaded controls Pin
antony beula15-Jan-10 0:01
antony beula15-Jan-10 0:01 
AnswerRe: how to convert dataset to excel retaining page loaded controls Pin
CikaPero9-Mar-10 23:11
CikaPero9-Mar-10 23:11 
QuestionWich dataaccess metod is faster - with datareader when the data is return from stored procedures or with LINQ Pin
Lyubomir Rumenov Velchev14-Jan-10 23:06
Lyubomir Rumenov Velchev14-Jan-10 23:06 
AnswerRe: Wich dataaccess metod is faster - with datareader when the data is return from stored procedures or with LINQ Pin
elizas14-Jan-10 23:22
elizas14-Jan-10 23:22 
AnswerRe: Wich dataaccess metod is faster - with datareader when the data is return from stored procedures or with LINQ Pin
Ennis Ray Lynch, Jr.15-Jan-10 3:13
Ennis Ray Lynch, Jr.15-Jan-10 3:13 
GeneralRe: Wich dataaccess metod is faster - with datareader when the data is return from stored procedures or with LINQ Pin
Lyubomir Rumenov Velchev15-Jan-10 3:41
Lyubomir Rumenov Velchev15-Jan-10 3:41 
GeneralRe: Wich dataaccess metod is faster - with datareader when the data is return from stored procedures or with LINQ Pin
Ennis Ray Lynch, Jr.15-Jan-10 3:50
Ennis Ray Lynch, Jr.15-Jan-10 3:50 
I have a system which I currently maintain that I converted one report from LINQ to the Data reader method. The one report was estimated to have a run time of a week with LINQ (we never let it finish just did timings on subsets) and the data reader version takes 30 seconds. Admittedly the LINQ version could have been cleaned up but LINQ encourages bad code so that needs to be watched for as well. In general

Data Readers with integer column indexes on well written stored procedures: fastest
Data Readers with string column indexes on well written stored procedures: 10x slower
LINQ 20x to 100x slower. Some situations LINQ will be just as fast as data readers but never faster.

You can ignore the size of the database for the discussion. If you want statistics there is someone who did a nice little timing comparison between all of the methods (you can search Google if you want) or you can take my word for it.


Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane


GeneralRe: Wich dataaccess metod is faster - with datareader when the data is return from stored procedures or with LINQ Pin
Mycroft Holmes15-Jan-10 11:42
professionalMycroft Holmes15-Jan-10 11:42 
AnswerRe: Wich dataaccess metod is faster - with datareader when the data is return from stored procedures or with LINQ Pin
Not Active15-Jan-10 6:10
mentorNot Active15-Jan-10 6:10 
QuestionGenerate report and download without refreshing (post-back) the page Pin
Rafferty Uy14-Jan-10 20:47
Rafferty Uy14-Jan-10 20:47 
QuestionWhy do I get "Could not load type 'AdamItiel.GlobalApp'"? Pin
senglory14-Jan-10 20:27
senglory14-Jan-10 20:27 
QuestionHow to know client IP Address ? Pin
Samarjeet Singh@india14-Jan-10 20:16
Samarjeet Singh@india14-Jan-10 20:16 
AnswerRe: How to know client IP Address ? Pin
thatraja14-Jan-10 20:36
professionalthatraja14-Jan-10 20:36 
GeneralRe: How to know client IP Address ? Pin
Samarjeet Singh@india14-Jan-10 23:14
Samarjeet Singh@india14-Jan-10 23:14 
GeneralRe: How to know client IP Address ? Pin
Manas Bhardwaj15-Jan-10 0:56
professionalManas Bhardwaj15-Jan-10 0:56 
GeneralRe: How to know client IP Address ? Pin
thatraja15-Jan-10 3:06
professionalthatraja15-Jan-10 3:06 
AnswerRe: How to know client IP Address ? Pin
April Fans17-Jan-10 16:32
April Fans17-Jan-10 16:32 
Questionasp:menu control works slow in ie7 Pin
sanjubaba14-Jan-10 18:22
sanjubaba14-Jan-10 18:22 
QuestionHow to create .Net application similar to a source safe(VSS) Pin
Pradyumna Sarode14-Jan-10 11:25
Pradyumna Sarode14-Jan-10 11:25 
AnswerRe: How to create .Net application similar to a source safe(VSS) Pin
leckey14-Jan-10 16:26
leckey14-Jan-10 16:26 
QuestionNewbie - 2 questions Pin
Mike65432114-Jan-10 8:12
Mike65432114-Jan-10 8:12 
AnswerRe: Newbie - 2 questions Pin
David Mujica14-Jan-10 8:48
David Mujica14-Jan-10 8:48 
GeneralRe: Newbie - 2 questions Pin
Mike65432114-Jan-10 8:59
Mike65432114-Jan-10 8:59 
AnswerRe: Newbie - 2 questions Pin
Not Active14-Jan-10 9:48
mentorNot Active14-Jan-10 9: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.