Memory problems? Please help.
Vincent Kennedy found data conversion routines on SCO UNIX 5.05 with Informix v7 got slower as each function ran in one compiled executable, though prepared statements were freed. Replies suggested freed statement memory is only reused, not returned to the OS; Paul Watson advised watching memory with ps; Watawinona asked about connection type and freed cursors. Vincent's version did not support onstat. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.