Re: 2 Instances, 1 machine VS 1 Instance 2 databases

From: Keith L Morris <keith.l.morris@wcom.com> > >The current job I find myself in was setup with 2 INFORMIX instances >each with one database. (On the same machine.) > >We have applicattions that link to both concurrently and do work. > >I would THINK that ONE instance with TWO databases (giving the one >instance all the CPU, DISK etc that BOTH originally had) would end up >being FASTER than the current scenario. > >Anybody have ANY experience with this kind of situation? > >(The current project lead thinks the database engine is the >bottleneck....... I'm thinking that it's the application code AND things >like this architecture. Although in defense of the architecture... >I think the original developers thought they may some day put each >instance on a DIFFERENT machine. But NOT SO.) > >We've recently started using the STATEMENT CACHE and had a major >increase... although we had to "LOOP OUT" a lot of the SQL code because >it was written in such a manner that it was NOT cacheable. (I will be >fixing that SOON.) > >Anyway.... any real world or benchmark info on the 2 instace - 1 db each >VS 1 instance 2 db would be GREATLY appreciated. > >(I have not seen any documentation concerning this in the Informix >Performance manual. Although I WILL be perusing the manuals this >afternoon.) There is no hard and fast rule, but in general I'd tend to agree with you. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com