Re: informix server information

From: wildpony <z1wildpony@hotmail.com> > >what about NT? What about it? :-) >what informix server engine would perform better with batch processing >verus >OLTP or datawarehouse IDS (7.31 or 2000) is great for Batch, OLTP and smallish DW. XPS is great for f...huge DW RedBrick is great for small to big DW. >approx how many databases can be running on one OS system Databases? No limit, really. I'm in a site where they have about 20 databases running for development on a Sun E450. >ie: oracle recommends no more than 3 instances per unix /nt server Ghmpf. Bwahahahahahahahahahahahaha!!! OK, well there are two different concepts here: Informix allows multiple instances as well as multiple databases within an instance. I've happily run a dozen *instances* on a SCO box. :-) >SQL Server really gives you no limits > >If I had many clients would it be better/more efficient to put each client >in >its own schema or database >ie: when using oracle if I put each client in its own instance then I have >to >deal with a seperate SGA <<system global area>> for each instance >SQL server you just add a new database within the sql server This is a bit of a difference in terminology. I'm not sure I'd recommend a separate instance with its own "SGA" for each client, but I would back the idea of multiple databases within one instance. >Pricing comparable to DB2 Uhhhh, I have no idea. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com