Subject | Re: Neewbie: Time Query Execution |
---|---|
Author | jvacompie |
Post date | 2006-12-01T09:03:13Z |
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:
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:
>to
> 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.a=ibphoenix&page=ibp_ss_vs_classic
>
> 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?
>per
> 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
>