Re: 4GL coding
David Williams wrote:
>
> In article <6a36vg$pc4$1@mendelevium.btinternet.com>, Graeme Norton
> <Graeme.Norton@btinternet.com> writes
> Not sure, but doing
> select mycolumn
> from mydb@myserver:mytable
> is slower because Informix will connect via the network even if
> the database is actually on the local server.
Not true. The connection type depends on the type defined in sqlhosts
for the named server (myserver), if myserver is declared as a shared
memory connection then the connection is shared memory, if myserver is
the same as $INFORMIXSERVER then the @myserver is completely redundant
and prevents the code from being run on a sister machine or development
server.
Art S. Kagel