Re: Connection is closed, but not disposed or released
Posted by:
Karel Boek
Date: January 25, 2005 08:50AM
So far so clear Terri, but the strange problem I have is that each DataAdapter requires a new connection to the database, while all DataReaders can reuse the same connection from the pool when the connection is properly closed after use.
The frontpage of my website had two DataAdapters and two DataReaders before, which meant 3 unique connections to the database for each visitor - imagine our website having 10s of thousands visitors a day. Now I use only DataReaders, I open the connection, execute the command, bind the results to a datagrid - or load a single result into a variable - and close the connection. Works fine and I don't experienced lower performance (not yet at least :-)
Does That Make Sense?