"CollyMitch" <colmjmitchell_at_gmail.com> wrote in message
news:1147271598.236262.272930_at_j73g2000cwa.googlegroups.com...
> Hey,
>
> Thanks for your reply.
>
> We retrieve 50 thousand rows from oracle (we only use oracle) because
> we want to download from the remote Oracle db to a local MS Access
> database, removing the need for a live oracle connection and allowing
> production to continue if the network is down. This may not be the most
> ideal way, but it was required when the network was prone to failures.
>
> We don't *want* to cache them on the client but load, record by record,
> into the access db - the virtual memory caching is the issue we need
> fixed! The issue is that it loads all the records into memory and the
> PC (Win2k) soon runs out of virtual memory.
>
> With Oracle 8 it doesn't seem to cache all the records on the client. I
> guess it caches one record at a time, does some work then removes it
> from cache, but not with 9 or 10.
>
> Could this be an issue with ADO or the Provider not being compatible
> with Oracle 9 or 10?
>
> Thanks again,
>
> Colm
>
I would look at the ADO. I have used Oracle Ole Objects in VB and never
encountered this type of problem. The Oracle middleware doesn't drag the
whole result set across unless you tell it you want it to. Then it doesn't
do any caching. ADO is just an API on top of the OCI (Oracle Call
Interface).
Jim
Received on Wed May 10 2006 - 20:53:11 CDT
