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

Billy Wheeler wrote: > > Rob Culhane wrote: > > [SNIP] Something about a quest for the Holy Grail ;-) > > Aha. Aha. Ahahahahahahahahahahahahahahahahahahaha!!! > > So let me get this straight: you want to start with 100+ users of an > OLTP-type apps on an NT box and grow to 400+ AND run a data warehouse > on one machine? > > Well, the only machine I'd consider for this would be something like > an IBM SP/2 or something of that ilk. 100 concurrent users could > probably run on a 4-way SCO UNIX box. I would not really consider > Intel/SCO for > 150 users and I wouldn't dream of loading more than 100 > users on NT anything. > Well, I wouldn't recommend 400 users on an SP2. The SP2 aka Lan in a can, works fine for a dabase app, or number crunching app, but you have multiple nodes. Try administering the system. Now, some of the SMP boxes like a J45 would work, or look at SUN, HP, Unysis, NCR for possible solutions. Depending on the app, you may be able to support that number of users. > And you should never run DW and OLTP on the same box. > Absolutely. IMHO, you would have to build a box which is partitioned such that it would be cheaper to buy to smaller boxes. Both OLTP and DW would put a large strain on the memory, disk and bandwidth to make this impossible. Of course, I think Billy and I think of DW in the 100+Gig database size. If your DW is < 10 Gig, then maybe you can do it. > -- > Ciao, > > Billy -Mikey -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resemblence to a coherent rational thought is purely coincidence. -The Management. #endif