Re: Is gradually increasing memory in long running session normal?

"Roland Wintgen" <rw@evg.de> wrote in message news:3F586828.2010002@evg.de... > Hi Fernando, > > I changed our programs to prepare lots of heavily used statements > instead of redeclaring the cursors. > > At least in one case it took me several months to identify one prepared > statement which wouldn't free the allocated memory. I used the following > identical syntax for several SQL-statements: > > let query = "select ..." > prepare query_prep from query > declare query_curs cursor for query_prep free query_curs > free query_prep > > This works for all but one function. The memory only gets released if > the program ends. After rewriting the code and declaring the cursor > every time it's used, everything works fine. > free the cursor as well (before the prepared query! > Can anyone corfirm this? > > We're using 4GL RDS 7.30UC6 with IDS 7.30UC10 on SCO Unixware 7.1.1 and this > was reproducable on RedHat Linux 7.3 4GL RDS 7.30UC5 and IDS 7.30UC10. > > > -- > Roland Wintgen (Systemadministrator) > > EVG Elektro-Vertriebs-Gesellschaft Martens GmbH & Co KG > Trompeterallee 244-246, D-41189 Moenchengladbach > phone +49 21 66 / 55 08 23, fax +49 21 66 / 55 08 90 > www.evg.de rw@evg.de > > > Fernando Ortiz wrote: > > Hi Dave: > > > > Several months ago one of ours 4GL programs made a lot of DECLARE > > CURSOR/PREPARE without FREEing them, and yes the memory usage was > > increasing. > > > > In my case I use onstat -g stm to locate the statements prepared, fgrep the > > source to locate the offending code and adding the missing FREE . > > > > HTH > > > > ----- Original Message ----- > > From: <dthacker@omnihotels.com> > > To: <informix-list@iiug.org> > > Sent: Thursday, September 04, 2003 3:55 PM > > Subject: Is gradually increasing memory in long running session normal? > > > > > > > >>I've been trying to debug a problem with a constantly running > >>application that is > >>experiencing a performance degradation over time. Today I set up a > >>script to > >>run onstat -g ses every 60 seconds and log the results. One of the > >>things that caught my eye is that this session's memory use increases > >>constantly over time. > >>For example, > >> > >> total > >> memory > >>13:38 1265664 > >>14:38 1977408 > >>15:38 2646016 > >> > >>Will the total memory ever decrease during the lifespan of a session? > >> > >>Dave Thacker > > > > > > sending to informix-list >