I've recently begun using Visual Basic dll's to increase the efficiency of my ASP pages, and I've got a question for all you programming gurus out there. What is best to use when getting a recordset? It seems to me that you have a couple choices...<BR><BR>1. Simply use the recordset while it's connected to the db<BR>2. Set the ActiveConnection to nothing and use a disconnected rs<BR>3. Loop through the recordset and store everything in a multi-dimensional array<BR>4. Loop through the recordset and put everything into a Collection<BR><BR>I know that choosing the 'best' of these most likely depends on your situation - but is there one that is usually better then the rest?