Re: DBMS Selection for 500+GB data and 500+ Users

CNRJ29A@prodigy.com (Leonard Spoden) wrote: >Oracle is the only proven solution on the market for your problem. >Informix has some nice "m-architecture", but is not proven in real life >situations with the number of users and size of DB you are talking. >If you are a DBA, you will love Informix because it requires constant >tuning! Job Security. >I would advise you talk to your Oracle Sales Consultant and find out the >truth behind Informix's tall tails that they have the only architecture >available to handle large DSS. Sounds like a sales pitch to me! Sorry, I don't buy it. I am running an INFORMIX 7.1 database on an AT&T GIS 3555. This server is running 5 instances of the INFORMIX engine with a total of 250 GB of disk on-line (almost all full too), 8 90MHz pentium processors and about 300 users in total. We are barely scratching the power in this box. CPU uitilization rarely goes above 20%. As to constant tuning, I have adjusted tuning parameters maybe three times in the last 4 months and that has taken all of 10 minutes. Ed Kelley, Senior Specialist AT&T Network Systems - CIO Email: ekelley@mindspring.com or ekelley@attmail.att.com WEB page: http://www.mindspring.com/~ekelley/html/ekelley.htm