Re: IDS Minimum Requirements?

I agree that trying to run IDS with 32Mb Ram equates will to running Win98 on 4Mb. However it should be able to work badly on 64Mb. (I have a client running a 5 user Workgroup Server on SCO with 64Mb Ram, 200Mb database and it runs badly). The CPU stats may be because SE uses Unix ISAM files, hence Unix is performing the IO, whereas IDS correctly configured will be doing the IO. Hence the IO that under SE was System CPU is now User CPU for IDS. It looks to me as if you inherently have a problem with the configuration or setup of your 7.30. Having said that IDS needs more resources, particularly memory, to "get it going". You need to configure IDS to the resources available and the requirements of the users. This is often a compromise. there is a lot of tuning available in the IDS configuration file and you need to be able to determine what is happening (short resources) and what resources are available while doing the sql. Have you run Update Statistics Medium on the table(s)? This is compulsary. Can you set explain on for SE and IDS engines to determine what each is doing. The simple answer may well lie with these results. To get back to your original question .... I think 32Mb Ram for AIX and IDS is very optimistic. 128Mb would be my minimum with an appropriately configured IDS and OS. Murray Wood ----- Original Message ----- From: Jay Turner <tjay@edcpub.com> To: <informix-list@iiug.org> Sent: Saturday, 22 May, 1999 03:24 Subject: IDS Minimum Requirements? > We are currently upgrading from Informix SE Ver. 5.01 to IDS Ver. 7.30 > Workgroup Ed.. Before we started on our production machine (RISC 6000 59H, > 1 gig mem., AIX 4.3) we first decided to upgrade our development machine > (RISC Power Server 350, 32 meg mem., AIX 4.3) to recompile the programs and > make sure everything works ok. The problem is that the IDS is extremely > slow on the development box. A simple program with two loops performing > 1000 inserts then 1000 updates takes over 2 minutes on the new IDS, where as > it takes 17 seconds on the old SE. So we called Informix fishing for > information they told us to upgrade the memory so we did, going to 64 meg., > exact same results on both versions. When I talked to Informix I also told > them about the cpu statistics I monitored using vmstat. When I run the test > program on the IDS server the cpu averages 98 user 2 sys., with SE version > it averages around 60 user 25 sys. As you can imagine with that much cpu > resources going to IDS it just kills the system and all other processes > really drag. The guy I talked to at Informix really didn't give me any > minimum requirements, and he seemed to think that it should run fine on the > 350. So my question is, is he correct? Or is this like trying to run > Windows 98 on a 486 with 4 meg mem.? > > Any responses will be greatly appreciated. > > Thanks, > Jay > > >