Subject Re: MultiThreading question
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, "Raymond Ferland"
<rferland@c...> wrote:
> To make a test, i Start a client and I do a SELECT * FROM CLIENTS
and, at the same time,
> a second client wich select only one particular client. The two
datamodules are created, two connections
> to the Firebird server are made but the two queries returns at the
same time.
>
> Is this the way the Firebird server works?

If it is Superserver - more or less similar. If critical resourse
is CPU - Classic is much better on CPU sharing, though loses in
single-user and low loaded multi-users modes. There is one more issue
- if you use local connection string like 'C:\mydatabase' -
serialisation of queries is made in client library, if TCP/IP, like
'localhost:C:\mydatabase' - in Supersrever internal threads only.

Best regards,
Alexander.