Subject Re: Neewbie: Time Query Execution
Author jvacompie
Hi,

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?

Thanks

--- In firebird-support@yahoogroups.com, "Markus Ostenried"
<macnoz@...> wrote:
>
> On 11/29/06, jvacompie <jvacompie@...> wrote:
> > Is it ok? or must I configure the server to create more process
to
> > 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:
> http://www.ibphoenix.com/main.nfs?
a=ibphoenix&page=ibp_ss_vs_classic
>
> 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
per
> connection -> can use all CPU cores -> allows parallel execution of
> queries in different connections
>
> HTH,
> Markus
>