Re: Memory problems? Please help.

From: "Vincent Kennedy" <vkennedy@torex.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? Does this run in a transaction? If so, can you split it into multiple transactions? I've found that long transactions slow down badlythe longer they get, I've never been able to figure out why. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com