This
article introduces some of the basic data-access performance issues to consider while developing database applications using ADO.NET. It shows you how to analyze network load, load on the database server, un-optimized SQL, opening and closing a connection, fetching a result set, blob access, and metadata retrieval. It then provides suggestions for improving database application performance.