Subject Re: [firebird-support] Accessing the same FB DB in different modes
Author Ivan Prenosil
Hello Martijn,
>> > However, a full "local" connection (without "localhost" in front of it)
>> > will block other threads (on SuperServer). On classic, it's fine.
>>
>> Can you be more specific ? Which operations are blocked ? Can you send
> example ?
>
> As far as I know, a local (IPC?) connection will block other
> networked connections when doing its stuff.

So, can you send some example or describe which operations are blocked ?

I just did simple test - I connected to DB using local protocol
and started 5 minutes long query. During that time I connected
from another application using local protocol (connecion was instant),
and then run simpler query, which returned result nearly immediately.
Then I tried networked connection and did the same test,
the connect and query were fast again (while the first application/query
still running). So, what should I do to see this "blocking threads
with local connection on superserver" problem ?

Ivan