I have always avoided allowing the user to create a local connection on the
server while other machines
access the database using TCP/IP because previous versions of firebirds
(before 1.5.2) seemed
to not allow this.

I am currently running 1.5.2 superserver and my tests indicate the same as
Ivan's, that you can be
running the database locally on the server computer while a client is able
to make a TCP/IP connection
without any problem.

I'm wondering if its possible that running this configuration over a period
of time could corrupt the
database. Is the database aware that more than one user is using it?



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ivan Prenosil
Sent: Tuesday, 28 June 2005 11:44 PM
To: Firebird-Support
Subject: Re: [firebird-support] Accessing the same FB DB in different modes


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





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]