Connection count and Threads

[Ruslan Zasukhin]

On 18/2/08 7:48 PM, "Mr. Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> Hi List,
> 
> anybody care to explain the use of threads (and the implications of
> the use of threads) and what does connection count learn me (is at the
> moment at 808, what does that mean?)

Threads 

* VSERVER have inside N worker threads.

* if you hardware have single CPU, then it is not wise set many threads.
        4-10 will be good.

    because then you start waste time on thread switch.

* if you have 4-8 CPUs then can be good idea raise this parameter.

And as always, often only experiment will show you the best values for your
hardware + db + tasks.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]