Hi,

We are upgrading from oracle 8 to oracle 10g. We have about 30 VB6
applications which connect to our oracle 8 database.

When connecting to Oracle 9 and 10g and the app tries to retrieve a
recordset (50,000+ records), it seems to load the whole recordset into
memory (RAM), and then into virtual memory when this fills up. (I can
show you the system performance graphs.)

I know this is not a VB forum but my code works with oracle 8 and not 9
or 10 so I think maybe someone here could help.

FYI:

Using ADO2.5 (or 2.8) to connect and the "OraOLEDB.Oracle" provider.

I can post some example code if required.

Thanks,

Colm