TOraQuery, memory consumption

MikeG · Post by **MikeG** » Thu 03 Jan 2008 10:55

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.

Plash · Post by **Plash** » Thu 03 Jan 2008 11:06

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

MikeG · Post by **MikeG** » Thu 03 Jan 2008 11:30

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.

Plash · Post by **Plash** » Thu 03 Jan 2008 12:25

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

MikeG · Post by **MikeG** » Thu 03 Jan 2008 14:41

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.

Plash · Post by **Plash** » Fri 04 Jan 2008 10:37

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.

MikeG · Post by **MikeG** » Fri 04 Jan 2008 19:02

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

Thank you very much for your help.

Walter Weiss · Post by **Walter Weiss** » Mon 07 Jan 2008 09:04

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?

Plash · Post by **Plash** » Tue 08 Jan 2008 15:11

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