Re: Size of SQLExec

In article 593@netcom.com, gabriel@netcom.com (Gabriel Beccar-Varela) writes: | After years of using an informix database, I noticed for the |first time that the sqlexec's use of memory (virtual memory) keeps growing |with every select until you quit the program. In other words, it is |theoretically possible to use all the resources of the machine if you |keep making queries for a long time without closing the application. | I would appreciate comments, ideas, suggestions on how to deal |with this problem. |-- |Gabriel Beccar-Varela Internet : gabriel@netcom.com | Voice : (510) 654-2030 | Fax : (510) 654-3182 We are using version 4.10(UG1 I think) of OnLine under SunOS 4.1.3, and we find that the _sqlturbo_ process grows, when you change databases (ie close the current database, and open another), perform a query, and change back again. (I assume that this is the same problem that you are experiencing.) This is a recognised bug in OnLine, and the bug number is 15129. The bug is supposed to be fixed in version 5.02. We are currently in the process of upgrading to 5.02, so I cannot tell you how well it works :). If this problem means that you run out of memory (once sqlturbo gets to a certain size you get the error message "Cannot allocate memory for sort" or some such error) you can do one of two things: 1) Increase the address of SHMBASE in your config file. (This does not alleviate the problem, but it means your program does not crash.) 2) Every so often, close your database, call sqlexit (see the manual) which will kill off your sqlturbo, and then open the database again. This will stop your program consuming resources, but it will take time to restart the sqlturbo. For use, the former alternative is preferred as we have a program that does a _lot_ of database swapping (hey, why not use a synonym?) and to periodically restart the sqlturbo would be too time consuming. If we restart the program at least every day, we don't run out of memory. Ben Kelley (Waiting for 5.02...) -- Ben Kelley (Good Guy) - SBC Australia Ltd. You've got the whole world in your hands. - Mastercard ben@syd.au.swissbank.com (Preferred) kelley@il.us.swissbank.com (NeXT mail OK) Who's got the whole world in his Phone +61 2 258 2382 ("Hello, this is Ben.") hands? The Master, not the card.