Subject | MultiThreading question |
---|---|
Author | Raymond Ferland |
Post date | 2004-05-18T14:33:02Z |
Maybe I'm wrong but I read somewhere in the features of FireBird 1.5
that the queries would be threaded, meaning that a slow query
would not prevent a faster one to be executed at the same time.
Yesterday, i have installed Firebird 1.5 SuperServer on my machine.
I run a server application wich can create datamodules on the fly
as needed by the connected clients.
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 so, how is it possible to use it in a multi-user environment and keep it
fast enough?
Raymond Ferland
Programmeur/analyste
Increase your image with professional voices!
Compro Communications
Your ideas... Our voices
1097, Boul. de la Chaudi�re
Cap-Rouge, (Qu�bec)
Canada G1Y 3T4
(418) 652-1490 poste 310
RFerland@...
[Non-text portions of this message have been removed]
that the queries would be threaded, meaning that a slow query
would not prevent a faster one to be executed at the same time.
Yesterday, i have installed Firebird 1.5 SuperServer on my machine.
I run a server application wich can create datamodules on the fly
as needed by the connected clients.
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 so, how is it possible to use it in a multi-user environment and keep it
fast enough?
Raymond Ferland
Programmeur/analyste
Increase your image with professional voices!
Compro Communications
Your ideas... Our voices
1097, Boul. de la Chaudi�re
Cap-Rouge, (Qu�bec)
Canada G1Y 3T4
(418) 652-1490 poste 310
RFerland@...
[Non-text portions of this message have been removed]