Re: New Era and backend memory

In article <34B3AE21.1535@wfsoftware.co.uk>, Paul Watson <paulw@wfsoftware.co.uk> writes >I've got a slight problem. I am currently looking after the backend of >site that is using New Era at the userend. Everything is hunky-dory >until the users start using the app and then the memory just gets eaten >alive. Typically onstat -g ses is reporting over 4MB per user which >seems to be a little excessive. Pulling out the SQL from the app and >running at the backend as a sinel SQL script doesn't cause any problems >- memory usage about 1MB. > >Anybody got any ideas where to look, please don't say ask the developers >'cos they are stuck too! > >TIA > Try running onstat -g ses for that session, what does it say. Also onstat -g afr <session-id> [Output will be large so send it to a file, just need to know where pool contains most of the memory] PS I reckon ralloc. How do you connect to the PC is it via an ODBC driver. If Intersolves this is a known issue which is being worked on]. We get up to 15Mb allocated!! -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care