Re: DBMS Selection for 500+GB data and 500

>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. Spoken like a true Oracle aficiando. Unfortunately, your so-called facts just ain't so, Leonard. Informix's products are, in fact, proven in real live situations with the number of users and DB sizes you refer to. Ask K-Mart or Home Depot - or Hyatt. It is NOT true that Informix requires constant tuning!! Once tuned correctly, the OnLine database engine remains that way. If you are observing that Informix requires "constant tuning" it's because whoever was doing the tuning was incompetent - or trying to fake up some job security. (Sideline: *all* database engines should have their tuned parameters revisited any time the workload for which it was originally tuned is significantly changed. In this respect, *all* database engines require "constant tuning".) I would advise anyone interested to read the Gartner Group's report and read the REAL facts. Computerworld (3/20/95, p.32) reports that "'Informix had the better architecture by far,' said Howard Fischer, senior project manager for database services at Sears Merchandise Group in Hoffman Estates, Ill." Informix's OnLine 7.1 runs rings around Oracle (whose representatives keep turning tail at every TPC-C benchmark shootout when Informix is present). Oracle simply cannot compete with OnLine 7.1. Face it, Leonard. You picked the wrong newsgroup in which to extol the so-called merits of Oracle. Or did you notice that you posted to comp.databases.informix? --- Bill Williams +-----------------------------------------------------------------+ | Disclaimer: My views, opinions, etc., are not those of AT&T or | | or ATSI, Inc, nor should they be. | +-----------------------------------------------------------------+