ADO.NET Performance Tuning

  • Thread starter Thread starter douglas
  • Start date Start date
D

douglas

Hello,

I have used ADO.NET to retrieve records (about 700 rows) from SQL2000 server
and found that the performance (speed) is not good as ADO object. (Same
Select statement applied)

I would like to askwhat setting, in the DB side or client sides,I should
aware so that I can improve the performance?

Thanks
Douglas
 
Hi Douglas,



Thanks for posting your question to the newsgroup.



A DataReader will give you the "best" performance when returning a set of
records from a select statement. It is read-only and forward-only. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/bdadotnetarch031.asp
for some detailed comparisons. (watch out for line breaks in the URL)



Hope this helps,

bliz


--
Jim Blizzard | http://weblogs.asp.net/jblizzard
Sr .NET Developer Specialist
Microsoft

Your Potential. Our Passion.

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to newsgroups only, so that others may benefit. Thanks.
 
Can we bind the DataReader to the DataGrid?
Jim Blizzard said:
Hi Douglas,



Thanks for posting your question to the newsgroup.



A DataReader will give you the "best" performance when returning a set of
records from a select statement. It is read-only and forward-only. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/bdadotnetarch031.asp
for some detailed comparisons. (watch out for line breaks in the URL)



Hope this helps,

bliz


--
Jim Blizzard | http://weblogs.asp.net/jblizzard
Sr .NET Developer Specialist
Microsoft

Your Potential. Our Passion.

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to newsgroups only, so that others may benefit. Thanks.
Click to expand...
 
DataReaders can be bound to a DataGrid--but only in ASP.NET applications.

hth

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top