Re: Memory Requirements of Sqlturbo's ?

In article <5680hr$7ek@cssun.mathcs.emory.edu>, Rajiv Jhaveri <rajivp@qsun.ho.att.com> writes >Hi : > > Is there a way to find out the memory required for each of the > sqlturbo process on the database server?. Yes, see below. > > Do each of these sqlturbos share any of the memory between them? Sql turbos do not share much memeory since they each have different parent processes. > > > Configuration: > Server : Sparc 1000, Solaris 2.4 , Informix On-Line ver 5.04 > Client : Sparc 20, Solaris 2.4 , 4GL application executable : 17Mb. > > > BTW : > On executing ps -l , each of these sqlturbo's showed up as ~13550 in the > SZ column. There are around 200 of these sqlturbo's running. > 13550Kb? Sounds rather large as does the 17Mb 4GL executable! I only every seen 1.5Mb. If you have 200 sqlturbos you could save a lot of memory by upgrading to Online version 7. Here you have a properly multi-threaded server with <15 server processes and no sqlturbos. > > > All help appreciated. > -- David Williams