Cross instance query performance tuning

Posted in 2000

Weaver, Bill — Fri, 27 Oct 2000 09:05:10 -0400 — source: Informix-list mailing list archive (1991-1998)

I have two instances of Informix running. On some limited situations I need to access a database running on the second instance from the first instance utilizing the database@aliasname:tablename <mailto:database@aliasname:tablename> syntax. I'm having severe performance problems with these queries. If I run the query directly on the instance I'm trying to access remotely, the query runs very quickly so it isn't the query itself - it's just executing cross instances where I'm taking all my performance hit. Is there anything I can tune/do to speed that up?

↪ replying to Weaver, Bill

smooth1 — Sun, 5 Nov 2000 22:05:18 -0000 — source: Informix-list mailing list archive (1991-1998)

What is the query? Run the query with SET EXPLAIN ON in dbaccess what do you get? Weaver, Bill wrote in message <8tc13i$5be$1@news.xmission.com>... > >I have two instances of Informix running. On some limited situations I need >to access a database running on the second instance from the first instance >utilizing the database@aliasname:tablename ><mailto:database@aliasname:tablename> syntax. I'm having severe >performance problems with these queries. If I run the query directly on the >instance I'm trying to access remotely, the query runs very quickly so it >isn't the query itself - it's just executing cross instances where I'm >taking all my performance hit. Is there anything I can tune/do to speed >that up?