LC 9 and Memory

[Stephen MacLean]

Hi All,

I’m running into an issue where LC 9.0.1 RC1 Business is running a process and is gobbling up memory and then not releasing it until I quit LC. Like 22GB of memory!

Let me describe what I’m doing: I’m getting a query back from a MYSQL DB that contains 32k records, all text. Using revQueryDatabase() to put the data into a record set and the move cursor to go through each record in a repeat loop.

During the loop, I’m calling multiple functions that use a variety of all the goodies LC has: tsNet directly to get some data and PUT and POST URL were they work fine (For some reason, they don’t work on some URL’s, but tsNet does). Processing that data and saving it back to the DB into a different table. While doing this I’m putting some text into a logging field, moving a progress bar and updating a counter field to show what record it’s on . I’m also running a timer to show the elapsed time.

When done I save the log fld to a text file, then clear it. I also close the record set.

The memory used for LC always goes up, but never goes down unless I quit.

What am I missing? LC does it’s own GC and memory management, but in this case, I don’t see it.

Anyone experience this before? Any tips for  controlling it?

TIA,

Steve MacLean