RE: Remote Databases

Chris Yes, there will be a significant difference. Using synonyms all the selected data from the remote tables is pulled onto your RS6000 before any sorts take place. Also your RS6000 is still having to contend with the application and database running together. You are also having to duplicate effort by archiving on two different machines, you might have consistency problems if you need to restore. Move your database entirely over to the Linux box and configure it to be a dedicated DB server (you will also benefit from the data reorganisation). Remove the database from the RS6000 and re-configure it to be a dedicated application server. Use the access method you have by changing INFORMIXSERVER and sqlhosts (I have 550 user sessions connecting to a database, albeit on the same box, using ontlitcp with no problems). Hope this helps Keith -> -----Original Message----- -> From: Chris Funderburg [mailto:Chris@Funderburg.com] -> Sent: Sunday, August 22, 2004 5:15 PM -> To: informix-list@iiug.org -> Subject: Remote Databases -> -> -> A couple of questions: -> -> We have a relatively old IBM RS6000. It's *really* pushed for disk -> space and upgrading it would be too costly. -> -> What I've done is move two of our biggest tables onto a much -> newer and -> faster Linux machine and created synonyms to point to the -> remote server. -> So far so good. -> -> My first question is, since we intend to keep running the 4gl -> applications on the AIX machine, is there any real speed difference -> between creating synonyms to the remote machine or by setting -> INFORMIXSERVER to point to the remote machine and having all -> the tables -> remote? -> -> Also, the line that does this in our sqlhsots file looks like so: -> -> net_sony2 onsoctcp dcisony2 net_sony2 -> -> Is there a faster or more efficient way to connect two -> databases than -> using "onsoctcp"? I vaguely remember reading somewhere that -> onsoctcp -> only uses one thread... -> -> Thanks, -> Chris -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list