Subject Re: [firebird-support] Re: Bad query optimisation on the MAC?
Author Helen Borrie
At 08:57 PM 30/11/2004 +0000, you wrote:
>Another gotcha with SS is that a local connection *must* be
> > via localhost on ***X. This differs from Win32, which allows SS to
>connect > locally without a hostname in the path.
>
>Can I clarify this - do you mean that when on the MAC, connecting to a
>database on that same machine you must use 127.0.0.1 rather than say
>192.168.0.100 (if that is it's IP address)? And you're talking about
>in the connect string?

If a local client connects (can connect) to its own IP address then it's
doing so via the network, i.e. it's a remote connection. No issues here.

Localhost (127.0.0.1) is a local loopback connection. For local
connections, *x SS must use this. The client for connecting to SS is
libfbclient.so.

Classic can also use libfbclient.so, and it's recommended that it be used
for remote connections. However, Classic also comes with a "direct local
connect" library, libfbembed.so, that can connect locally directly to the
database file. This library can't be used with SS at all.

libfbclient.so doesn't support direct local connect.

None of which accounts for the slowness of your expression calculations...

./heLen