Re: [Firebird-devel] Is it possible to run some queries in parallel?

[Dmitry Y. <fir...@ya...>]

Doychin Bondzhev wrote:

> So do you think similar execution plans be executed in parallel in case 
> there is more then one CPU/Core on the server?

If we talk about a dedicated multi-client server, then I'd suppose that 
number of active connections is going to be larger than the number of 
CPUs/cores on the server, so the available CPU power is already going to 
be utilized properly and I wouldn't expect much improvement from a 
parallel query execution. Also, many database operations are actually 
I/O bound and the CPU parallelism isn't going to improve them much.

The situation surely differs for an embedded single-user server usage, 
but I'm not sure this should automagically assign this feature a high 
priority.

So, maybe after v3.0, if someone would sponsor it...


Dmitry