RE: Informix Upgrade?

We have several 7.30 and 7.31 engines out there on Unix. We upgraded = one customer from 7.14 to 7.30. Most went from 7.20 something to 7.3. They run fine. A number of table join sqls, particularly more than 4 = tables, run much faster with 7.30 than 7.14. Run ALL onchecks imediately before upgrading -cdi {databases} -cc = -cr -ce READ the Release notes carefully!!! There are some differences in = shared memopry configuration requirements on some platforms. Murray Wood=20 -----Original Message----- From: martyn.ayshford@orange.co.uk [SMTP:martyn.ayshford@orange.co.uk] Sent: Friday, June 25, 1999 9:24 PM To: informix-list@iiug.org Subject: Informix Upgrade? We are about to upgrade a number of large instances running 7.14 to 7.31 these are OLTP systems with 4QL applications talking via encina middleware to large HP-UX 10.20 systems acting as database engines. I am interested in hearing from users out there who have either done such a conversion or who run large high hit OLTP applications against 7.30/7.31 IDs. Problems, gotcha's, our particular concerns are the reliability under load of IDS 7.31 and it's performance. All connections are socket based. Cheers mja Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.