Keeping in mind that the number of connections is auto-expanding, and also my other notes from your previous post/question, if you approach or surpass the efficiency zone (500-700 active connections per listener), responsiveness to user requests will seem to be slow although once a request is picked up the response should be quick as usual.
The keyword here is "active" connections. If you have 9000 users connected but only 300 of them are actively submitting requests (new queries or even just "next block of data" requests) then you will still be OK.
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Mon January 11, 2021 01:44 AM
From: Jason Ball
Subject: NETTYPE connections per thread
Hi all
What is the impact of not having enough threads per connection.
NETTYPE ipcstr,12,200,CPU
VPCLASS cpu,num=12,noage,autotune=1,max=14.
How do I know if I am getting up towards that limit.
Regards
Jason
------------------------------
Jason Ball
------------------------------
#Informix