Re: 4GL coding

In article <34C7A8C0.72E4@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >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. > I can't find the reference, but it said something about using the loopback connection? Could have been where nettype = a network connection..I'll try to dig out the reference, the quote just stuck in my mind... >Art S. Kagel -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care