> Was the speed difference really big (how long was the select of all

rows) ?

The long query takes about 20 seconds and the short returns almost
instantly.

As other post to my request suggested, i tried to install the classic
server but the behaviour stays exactly the same.

Would i have speed gains installing my server on a Linux machine?

--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:

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