Re: 4GL 4.11 frontend via network to 7.30 backend
On Thu, 3 Sep 1998, Richard Spitz wrote: > from many discussions in this group and also from the manuals, I > always got the information that 4.x and 5.x frontend products (like > 4GL or ESQL/C) can only communicate with 7.x backends (like my brand- > new IDS 7.30) via the performance-eating "relay module". For this > reason, it was strongly advised to use at least 6.x frontends or the > new 4GL/ISQL 7.20. > > I've asked the question before in this group, but received no answer: > Is the above true also for socket connections via TCP/IP, or only for > situations where frontend and backend run on the same machine? > > I just tested a 4GL 4.11 program running on one machine with I-Net > 5.10 installed against another machine with IDS 7.30, connected via > LAN and using TCP/IP. I was surprised that this worked instantly, and > no relay module was used. Performance was not noticeably impaired. > With "netstat", I could see a connection on the "sqlexec" port. The local sqlexec was behaving like a relay module; it connected to the remote machine. > Does this mean that the TCP/IP socket connection protocol has not > changed between versions 4/5 and 6/7? Can I leave my appication > server as it is and just upgrade the database server to 7.30 without > suffering performance penalties? There's a penalty; you are talking to the local sqlexec and the local sqlexec is talking to the remote database via the network, whereas if you upgrade, the program will be talking to the remote database via the network without any intermediary process on the local machine. > Of course I know that is beneficial to upgrade the frontends to the > current versions, too (e.g. DBCENTURY), but this would increase the > timeframe for the migration considerably. You can run as you suggest. If the performance is adequate, fine. If not, then upgrade the frontends too. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn