Performance Stats for Online 7.x on the RS/6000
Posted in 1995
Topics: Performance & Tuning
Does anyone have performance data relevant to the RS/6000 and the Informix Online 7.x engine. Need to evaluate for the following situation: Uptime is normal at 5 by 24, bump to 7 by 24 for indeterminate times during the year 400 transactions/minute being added to the primary table 600 transactions/minute being read and updated within the primary table 400 transactions/minute being read, then deleted from the primary table primary table has approx 10,000,000 records 5 tables have approx 500,000 records 10 tables have approx 200,000 records Questions which are pending: IBMs HACMP - will it affect the performance, and how much? Various RAID options for a separate disk subsystem - performance considerations? Indexing, disk reclamation problems or concerns to keep in mind due to overall volume load. Please email if possible, as these answers are needed very soon, and I do not always have the time to search the newsgroup. Thanks