Can anyone please explain me the real advantage of using disconnected dataset in an OLTP system?

For example, suppose I want to connect to an Oracle table containing 1M rows. If I make a front end using Access or Developer 2000, I can scroll thru the records from front end at lightning speed. However, if I create a VB.NET form to show the records, thru disconnected dataset, it takes several minutes to load the whole things. I tried with far less rows (appx 20000) but still it takes long time to show the records.

My question is, how can it be done in VB.NET disconnected recordset concept?

I think, one often claim advantage of disconnected recordset is that it does not take up "valuable" resource by several connections. But is it true for all databases? Oracle has shared server feature which allows several thousand concurrent users without any problem.

Can anyone please explain the things?

Thanx a lot