Memory problems? Please help.

I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. They used to be executed during a shell script containing abotu 30 programs. However, this was poor for maintenance and distribution so one exe was compiled and the routines seem to get slower and slower as each function is called. Prepared statements are freed and the routines seem optimal. What have I missed. How does Informix manage memory? Cheers.

In article <8aqo1d$4gn$1@newsg1.svr.pol.co.uk>, "Vincent Kennedy" <vkennedy@torex.co.uk> wrote: > I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. > > They used to be executed during a shell script containing abotu 30 programs. > However, this was poor for maintenance and distribution so one exe was > compiled and the routines seem to get slower and slower as each function is > called. > > Prepared statements are freed and the routines seem optimal. What have I > missed. How does Informix manage memory? > > Cheers. > > I'm guessing that you're using esql. I'm not certain how 4gl handles it, but I'd guess it is the same. When you free statements, the memory isn't actually freed to the system, it's just unallocated for the program to use again. Check top or whatever you have to view memory statistics. This will tell you if the problem is really a memory issue. Have you updated statistics recently? How's you box set up? -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

Monitor the exe using ps and see if the memory is increasing, if it is then review the code and start releasing or re-using the memory Vincent Kennedy wrote: > > I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. > > They used to be executed during a shell script containing abotu 30 programs. > However, this was poor for maintenance and distribution so one exe was > compiled and the routines seem to get slower and slower as each function is > called. > > Prepared statements are freed and the routines seem optimal. What have I > missed. How does Informix manage memory? > > Cheers. -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #

the conversion functions get slower and slower? What is the connection type? shm or soc ? Did you FREE cursors? What does onstat -g ses sessid say? Does the executable grow in size? Nona >Subject: Memory problems? Please help. >From: "Vincent Kennedy" vkennedy@torex.co.uk >Date: 16.03.00 14:35 W. Europe Standard Time >Message-id: <8aqo1d$4gn$1@newsg1.svr.pol.co.uk> > >I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. > >They used to be executed during a shell script containing abotu 30 programs. >However, this was poor for maintenance and distribution so one exe was >compiled and the routines seem to get slower and slower as each function is >called. > >Prepared statements are freed and the routines seem optimal. What have I >missed. How does Informix manage memory? > >Cheers. >

Watawinona wrote in message <20000316144727.03156.00002715@ng-fo1.aol.com>... >the conversion functions get slower and slower? > >What is the connection type? shm or soc ? > What are these? >Did you FREE cursors? What does onstat -g ses sessid say? Does the executable >grow in size? > I did free all prepared cursors. I don't think the version I'm using allows 'onstat'. It doesn't understand this. Cheers.