Re: Session memory grows a lot

This kind of memory allocation can be caused by a "feature" in the INET driver (in a C/S environment). Use of ODBC and INET 5.01.WG1 or higher can cause problems. Try using INET 5.01.WF2 as a possible sol'n. The "feature" was explained to my by an I'fx engineer as a change in the way the INET driver handles the "free cursor" statement. Apparently, the default behavior is to not pass the request to the engine. The only fix was for the ODBC mfg to recompile their drivers with a different ESQL/C flag (or down-rev your INET driver). -d Thomas J. Girsch wrote in message <67bqun$irf$1@malgudi.oar.net>... >Are you closing your cursors and freeing your queries? Also, if you're >using stored procedures from within I4GL programs, there's a known memory >leak, that I don't think is fixed in 7.23. We had similar problems when >accessing via Netscape LiveWire. > >Make sure that your programs are closing all cursors that they open as soon >as they're done with them, and free all queries you prepare. > >Ivan Lopes wrote in message <67bm64$og9@cssun.mathcs.emory.edu>... >>Hi, >> >>I am having serious problems because the session memory grows too much. >>Some sessions at the end of the day have 20 Mb!!!! >> >>We use a lot stored procedures, cursors and temp tables, but I don't think >this could cause >>this HUGE memory allocation.( Informix 7.23 on DEC Unix 4.0) > > >