Memory Management

[kotikoti]

Query: Memory Management

Hi All,
Still working in the development environment and been puzzled with what is happening. The little application reads data from a sqlite file and dumps it into a field, I do however clear any variable that was used to hold the data at the execution of SQL, and what I am seing, watching the activity monitor, memory usage by the application simply keeps creeping up.

116MB (starting memory usage of RR 2.9 plus the little utility) , 207 MB, 255 MB, 311MB and so on, this eventually freezes the application (RR) and I have to drop it at the task manager level.

For a standalone application, trend is as follows (in brackets, once I have done SQL read)
5MB (253MB), 93MB (295MB), 198MB (333MB), 242MB (367MB)

My assumption is that if I put data in a variable/fld, this will use memory accordingly, and emptying these, would free same allocation up, what is happening is but the expectation. Any thought on this will be appreciated.

Code: Select all

--cleanup

put empty into fld "Field2"
put empty into fld "Field3"
put empty into tList
put empty into tSQL

Thanks

[Mark]

Dear kotikoti,

Please, create a standalone and test again. Your problem may be caused by something in the Revolution IDE rather than your stack or the database drivers/externals.

Best,

Mark

[kotikoti]

Hi Mark et all
I have tried the standalone one as well on both vista and xp, still same, memory usage creeps up...

[Bernard]

Are you using any global variables, script local variables, or sql cursors when you get/manipulate the SQL data?

Perhaps if we could see the code that leads up to you displaying the SQL data in the field.

Are you saying that on each fetch from the database that memory usage increases by 50mb or so?