| ActiveMac | Anonymous | Create a User | Reviews | News | Forums | Advertise |
|
|
|
User Controls |
|
New User |
|
Login |
|
Edit/View My Profile |
|
|
|
|
|
|
|
ActiveMac |
|
Articles |
|
Forums |
|
Links |
|
News |
|
News Search |
|
Reviews |
|
|
|
|
|
|
|
News Centers |
|
Windows/Microsoft |
|
DVD |
|
ActiveHardware |
|
Xbox |
|
MaINTosh |
|
News Search |
|
|
|
|
|
|
|
ANet Chats |
|
The Lobby |
|
Special Events Room |
|
Developer's Lounge |
|
XBox Chat |
|
|
|
|
|
|
|
FAQ's |
|
Windows 98/98 SE |
|
Windows 2000 |
|
Windows Me |
|
Windows "Whistler" XP |
|
Windows CE |
|
Internet Explorer 6 |
|
Internet Explorer 5 |
|
Xbox |
|
DirectX |
|
DVD's |
|
|
|
|
|
|
|
TopTechTips |
|
Registry Tips |
|
Windows 95/98 |
|
Windows 2000 |
|
Internet Explorer 4 |
|
Internet Explorer 5 |
|
Windows NT Tips |
|
Program Tips |
|
Easter Eggs |
|
Hardware |
|
DVD |
|
|
|
|
|
|
|
Latest Reviews |
|
Applications |
|
Microsoft Windows XP Professional |
|
Norton SystemWorks 2002 |
|
|
|
Hardware |
|
Intel Personal Audio Player 3000 |
|
Microsoft Wireless IntelliMouse Explorer |
|
|
|
|
|
|
|
Site News/Info |
|
About This Site |
|
Affiliates |
|
ANet Forums |
|
Contact Us |
|
Default Home Page |
|
Link To Us |
|
Links |
|
Member Pages |
|
Site Search |
|
Awards |
|
|
|
|
|
|
|
Credits |
 |
Performance Comparison: Data Access Techniques | |
|
||
| Time: 02:14 EST/07:14 GMT | News Source: Microsoft | Posted By: Robert Stein | ||
|
Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database. In these comparisons, a reference set of methods is executed against a reference set of Customer, Order, and OrderDetail data under a range of user load conditions. | ||
|
Write Comment
Return to News |
Displaying 1 through 25 of 150 Last | Next |
The time now is
3:23:19 AM
ET.
Any comment problems? E-mail us |
| #1 By 135 (208.50.201.48) at 2/4/2002 3:03:32 AM |
|
Interesting article. We were doing some of our own comparisons at work, experimenting with the use of XML versus ADO recordsets. In our case using DCOM as the transport. Somewhat similar results, the introduction of XML increased CPU overhead on both the client and the server, primarily because XML was simply the transport package it was converted into ADO to be processed at both ends.
However the nice benefit of XML is that there are fewer round trips on the network, so latency with our remote offices on the WAN was improved. I'll have to pass this article on to my coworkers. |
|
Write Comment
Return to News |
Displaying 1 through 25 of 150 Last | Next |
The time now is
3:23:19 AM
ET.
Any comment problems? E-mail us |
