Monday, January 01, 2007
Review Topic: SQL: Firehose cursors, and connection pooling
In working with Mirosoft SQL Server 2005 along with Visual Studio .NET 2005 and ADO.NET databases, a couple of concepts:
Firehose cursors: The SqlDataReader class fetches rows one at a time with a lock at on one row at a time. (A cursor means "current set of rows.")
SqlDataReader uses internal SQL format instead of DataSet (to convert intenrally to XML )for internal representation of data. This saves time at the expense of flexibility.
The .NET framework uses connection pooling, managing already-open connections to the database in a pool, to save resources in constantly opening and closing connections.