Re: My Informix Never free up memory!

steven@steven4u.net (steven) writes: > Hi, group > > My ESQL/C program run a insert/update loop to load about 90,000 > records from data file into tables. During run, I foud the share > memory size kept growing from it's initial size to 750M! My box only > got 128M physical RAM, I think it is a big performance problem for > Informix will cause a large disk swapping, won't it? > > Can anyone please tell me why Informix dont' free memory after every > excuttion of insert/update sql? I think I already free every sql id > after prepare & execute it. In fact, even after exit of the program, > the share memory size still dont go down. What it means? > > Below is some run time info, can anyone please checks and gives me and > advice. Can you pleasy clarify if this supposed memory leakage happens in the client or in the server? From your post I suspect you're talking about the server, but the answers here have all been talking about the client. 128M physical RAM is not very much these days, to put it mildly. -- 'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ogj@tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694