Re: theoretical conn or thread limits

2006-05-19 Thread sheeri kritzer
On 5/19/06, Lyle Tagawa [EMAIL PROTECTED] wrote: Given a nptl/linux box (or pthreads/freeBSD) for example, can you tell what is the theoretical max running thread count (in the context of paging/process scheduling and not in the context of memory sizing), assuming that there's no

RE: theoretical conn or thread limits

2006-05-19 Thread Lyle Tagawa
That's because ignoring cpu and query complexity isn't generally done. Sure, you can run a zillion queries per second if all you're doing is SELECT num from table;. But really threads are limited by memory I agree with many of your points. We tuned our per-thread buffers appropriately and