Re: Informix on NT platform - Impact of 100 to 400+ Users

"Rob Culhane" <gsdrtc1@worldnet.att.net> wrote: >We are considering implementing an Informix Online Rel 7 server in an NT >4 way SMP environment. We are concerned about the viability of initially >starting with 100+ users and growing to possibly 400+ users. Looking for >other people's experiences including maximum users on NT before >degradation? >Questions regarding impact of combining startup warehouse with OLTP >applications on same platform also exist. This morning, Informix released a press release about a BANN benchmark on NT. The benchmark simulated 760 users and gave response times of less than 3 seconds. They used one database server and two application servers. Each machine had 4 Pentium Pro 200s and 2GB of memory i.e. 12 Pentium Pros and 6GB of memory. I also suspect that the application is partitioned. I agree with other posts that you can't mix oltp and warehousing on the same machine. Use replication and put your oltp users on one and dw users on the other. If you can partition your application as well then it may work. David David W Chan GO5 Limited david@go5.com (work) dwc@cix.compulink.co.uk (home)