Re: Should we upgrade DB and 4GL???
Posted in 1999
Topics: Performance & Tuning, Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Internationalization & Character Sets
Steve, So far, my experience has been mixed. The engine 7.3 is far better than 7.2 in most regards (one unfortunate problem with the keyfirst queries). The optimizer hints (oops, "directives") are both handy, instructive, and reassuring me as to the usual quality of the query plans produced automatically. 4GL seems to work but the executables now include GLS support, and (in my case) grew 2-4 times in size from before. I was using compiled 4GL, stripping the results, and if there is an option to leave the GLS out of the finished product (assuming that this is what caused its girth to increase) I don't know what it is. It has been suggested that we use shared libraries, and I'm investigating the impact of that right now. HTH, David "Steven L Cooper" <scooper@thecompounders.com> on 01/26/99 09:26:57 AM Please respond to "Steven L Cooper" <scooper@thecompounders.com> To: informix-list@iiug.org cc: (bcc: David Coburn/ISG/WVUS/WorldVision) Subject: Should we upgrade DB and 4GL??? Plz post any good or bad stories you have about this setup! We are running INFORMIX OWS 7.20 and 4GL 6.02 on SCO 5.0.4 This configuration has run flawlessly for over a year. We are going to upgrade to 4GL 7.2 for Y2K, etc. Plan on moving to D4GL in the next year or so... Should we upgrade the Server (7.3?) at the same time, or just leave it at 7.2??? Steve -- Steven L Cooper Manager, Systems Engineering --------------------------------------- Please reply to NG only, so others may be enlightened... The views expressed here are mine and you can't have them...unless you agree!