🚀 go-pugleaf

You are using client-side cursor - it fetches all rows into memory. You can
use server-side cursor which will not fetch all rows into memory but some
features will not be available (for example, most OLEDB providers do not
implement sort/filter).

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Bonny Rais" <bonnyr@optushome.com.au> �������/�������� � ��������
���������: news:3e6c305a$1@newsgroups.borland.com...
> All,
>
> I find that an application I'm writing is taking a very long time to show
> up because a dataset which is connected to the database is taking long to
> complete. Is there anyt way to eliminate or amortise this time?
>
> The dataset is an ADO  table (I've tried queries as well) connected to a
> medium
> size table with about 70K records. It seems as if the application is
loading
> the complete
> table into memory (why?).
>
> Any help would be appreciated.
>
> Cheers,
>
> Bonny
>
>