Connection count and Threads

[Ruslan Zasukhin]

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

Hi Bart,

>>> 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?)
> 
> What about connection count ?

Ivan? :-)


>> 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.
>> 
> 
> Since the db is running on a quad core xserve and in activity monitor
> I see the load rise sometimes to 150% CPU (I suppose that is 1,5
> cores ), a number of 10 threads seems reasonable ?
> 
> Is there a relation between connections and threads ?

I have not catched yet about which connection count you talking.

You have Vserver Office unlimited?
    and you have now 800 live connections?

Or you asking about some parameter from the ini  file ?


-- 
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]