I have one confussion regarding the Usage of Collection and Disconnected RecordSet, Can anyone help me to explain me the Exact differene in Usage of Collection Vs Disconnected RecordSet. Currently i m using Collection to store data and retrive it for my Three tyre application but i m feeling very slow performance using it, can anyone give me exact idea of usage of Collection or Disconnected Recordset with regard to Memory Usage and Speed Performance for Database based application.



Anand Patel
Xtreme Infotech Solutions
www.xtremeinfos.com

A disconnected recordset is an object with properties and methods explicitly tailored to handling data. It should be quite speedy once it has its data.

Using a Collection, you sort of have to redesign the wheel, so to speak. Memory usage probably doesn't matter much, that goes on kind of 'under the hood.' You don't need to know much about how an engine runs to drive a car.
I would expect using a collection to be more error-prone, take maybe 5 times as long to write the code, and I would expect it to be slow.