Subject Re: Neewbie: Time Query Execution
Author jvacompie

but reading your link, the superserver seems better than classic and
it should allow parallel execution of queries in different
connections with the threads.

"SuperServer allows for a fixed number of database threads to be
multiplexed over a potentially large number of concurrent database
connections. Since these threads are not hard-wired to any specific
database connection, SuperServer can support a larger number of
users with minimum resources use."

Is there any way to increase the number of threads?


--- In, "Markus Ostenried"
<macnoz@...> wrote:
> On 11/29/06, jvacompie <jvacompie@...> wrote:
> > Is it ok? or must I configure the server to create more process
> > listen? I've not seen anything in the "firebird.conf" file.
> Hi,
> you may want to read this article explaining the different
> architectures of firebird server that you can install:
> In short:
> Super Server: shared cache -> lower memory usage; one process that
> uses one CPU core
> Classic Server: no shared cache -> uses more memory; one process
> connection -> can use all CPU cores -> allows parallel execution of
> queries in different connections
> HTH,
> Markus