DataBase problem ...

[yaniv_av]

Hi,

I'm using the RecordSet class for ORACLE DB.
The dll is msorcl32.dd version 2.5.
I have a very big DB staff to load, and when I'm using a "snapshot" access, the cache is growing to giant size...
Is there is any option to limit the cache size ?

On the other hand, when I'm trying to use the "dynaset" option, I have a deadlock at some phase...

Do you have any solutions ?

10X!

[GCDEF]

I don't believe you can limit the snapshot size. What would be the point? You'd miss some data. I'd be debugging the dynaset option if it were me.

[yaniv_av]

I have tried to debug the dynaset option.
It seems that it entered a deadlock (endless loop) somewhere within the dll (Assembler code). That happened after loading alot of date from the DB. From some reason, It stuck in the middle....

[GCDEF]

Is there a different ODBC driver available? Is the server trying to respond to your request? If you use a filter to limit the size of your query results does it work?