Lobs: How to load them only on demand?

[Roeland]

Hi,

When opening a cursor which have lob-columns, the OracleDataSet loads all the lob data for each record. Is there any property, setting, method or event that postpone this loading until needed?

If Answer = yes then
  how?
else
  Make it a feature please;
end if;

This will solves many issues at once:
- Slow Query performance
- Cumbersome Query writing (versions with and without lobs)
- Less memory usage
- ...

Roeland

 

[Marco Kalter]

There is currently no option for this. I have added it to the list of enhancement requests.

At the moment you would have to exclude the LOB from the query and fetch it on demand within the application.