Re: [Firebird-devel] 32-bit Firebird attempting to create large amount of thread on 64-bit server

[Vlad K. <hv...@us...>]

> 27.01.2011 13:28, Dimitry Sibiryakov wrote:
> 
>> Exactly to make threads' creation/deletion seldom. Sleeping thread consumes no resources.
> 
> Doesn't 2MB of stack count, especially when you have hundreds of them?

    Dealing with 'out of memory' conditions - yes, counts. Especially for 32-bit process.

    Imagine application server wich creates own pool of connections at startup. It easy could 
force Firebird to create 100th of threads for a short period of time. Then app server start to serve 
users and some of them requires much memory. But we can't allocate it just because we have 
100th idle worker threads wasting 100th of MBs of virtual adress space. 

    Just dumb example of course :)

Regards,
Vlad