> 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.

Right, but scheduling/switching of threads is performed by operating
system. Some OS (Windows) are known to have pretty bad scheduler.
Also, queueing of requests to disk operations (by OS) can have impact.
Was the speed difference really big (how long was the select of all rows) ?

Ivan

----- Original Message -----
From: "Raymond Ferland" <rferland@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, May 18, 2004 4:33 PM
Subject: [firebird-support] MultiThreading question


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@...