Subject | Re: [firebird-support] Accessing the same FB DB in different modes |
---|---|
Author | Ivan Prenosil |
Post date | 2005-06-28T13:44:11Z |
Hello Martijn,
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
>> > However, a full "local" connection (without "localhost" in front of it)So, can you send some example or describe which operations are blocked ?
>> > 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.
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