Re: Can 4.0 SE & 7.1 SE coexist?

At 06:16 PM 8/22/97 EDT, you wrote: } }On Fri, 22 Aug 1997 14:13:46 -0400, "Joe" <joe@colsys.com> wrote: } }> We have a client using Informix SE 4.0 on a SCO Unix system. They want to }>access the database with ODBC, so they upgraded SE 4.0 to 7.12, which }>includes Informix-Net. }> }>The problem is that their Unix application was written using the 4.0 tools }>and hence needs to use the Relay Module (sqlrm) to run. They are }>complaining that the application is now much slower, probably because of the }>relay module. } }This is an aside but I would certainly look at page level locking as a }potential culprit here. I dont think the relay module is that much }slower though Ive never used it on a 4.X database } page and row level locking differentiation exists only in OnLine environments. SE uses the UNIX file management. I think you'd have to look at what benefits your old version Tools (4GL 4.x) would get out of the newer version Servers & Connectivity (SE 7.x). I recall somewhere (Installation Guide in your Informix media box?) that there is a matrix with this information. Aside from this, your best bets are version specific tuning (kernel parameters, placement of data on disk, re-indexing, update statistics, etc). I would advise upgrading your Tools to 6.x (look at 6.04 or 6.03) to get better behaviour. Why did you decide not to upgrade the tools with the server? }> }>My idea is this: On the Unix system, continue to use the SE 4.0 engine to }>access the database, but still run the 7.12 sqlexecd so ODBC can be used to }>access the database. This will avoid the relay module. However, it means }>that both the 4.0 engine and the 7.12 engine will be accessing the same }>database. }> }>We have not tried this yet, but could it cause problems (such as...)? }> }> }> }> }> }> }> } }Mike South } }Producer/Director }"Mike South's Southern Belles" }"Mike South's Travels" } }Winner 1997 AVN Best Amateur Video }Winner 1996 Rocky Mountain Oyster Readers Poll Best Pro-Am Series } } Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+