Devart Forums

I'm using ToraQuery (ODAC6.25; Delphi 7) to receive hundred thousands of records from a simple table with SDO_Geometry data (triangles).
The properties unidirectional and readonly are set to true.

A simple browsing through the result records (from the first to the last record) needs hundreds megabyte of memory.

I read about the the problem that the memory will not be freed after the query closes but how can I prevent the growing memory consumption?

Thank you in advance.

We have fixed the problem. The fix will be included in the next build of ODAC.

Thank you very much for the fast response.

When will the next build of ODAC be available?

or

Can I fix the problem by myself?
I bought the package with the source code.

Please see my answer at the following topic:
http://crlab.com/forums/viewtopic.php?p=32105#32105

I've tried this already before I posted my problem here, but
this didn't solve my problem.

My problem is at first the dramatically growing of the memory consumption while browsing through the records . This process takes too much memory.

Is this problem solved too?
Any further hints?

Thank you in advance.

Possibly you have missing something while changing ODAC source code. We are planning to release new ODAC build with the fix on the next week.

I've reinstalled the corrected package and TOraQuery works great now.

Thank you very much for your help.

I've got the same Problem.
I'm using TOraStoredProcedure in Direct Mode with
ScrollableCursor := TRUE, ReadOnly := TRUE
when scrolling from first to last Position the Proceure crashes because of to less memory(2GigaByte).
Will the next Release fix this too?

ODAC does not support scrollable cursors in Direct Mode. You can set the UniDirectional property to True, if it suits you.