Hi, ...... >>But anyway, even ~1000 client-server connections are VERY huge number, >>that needs special hardware infrastructure to implement that. So, this >>is not only about "firebird limits".
i have now near 400 connections and do not see any problems with resources or server response. But i really care about query plans and optimizations - may be this is the reason. Within a year I expect a tripling of the number of connections (fixed not pooled) And this is the reason of question. I see that i still not reach limit 2048 - then i still have reserves. regards, Karol Bieniaszewski -----Oryginalna wiadomość----- From: Dmitry Kuzmenko Sent: Thursday, January 21, 2016 4:56 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] ODP: Re: fb3 connections limit Hello! Thursday, January 21, 2016, 6:06:06 PM, you wrote: l> may i ask what is the reason of that limit on windows? that type of interest is suspicious. Currently, huge companies works in client-server mode with 500-700 simultaneous connections, without any problem. When someone asks about 2000 connections, seems that he need connection pooling and 3-tier architecture, rather than client-server. Because, for example, maybe 10 years ago Linux had limit of 600 connections, and to increase it, you needed to recomplire the core. So, question like that is not normal. As it was said, Firebird have limits close to OS limits, or depends on OS limits. Well, then, what else do you need? Want 3000 connections at Windows? Ask Microsoft about that. But anyway, even ~1000 client-server connections are VERY huge number, that needs special hardware infrastructure to implement that. So, this is not only about "firebird limits". -- Dmitry Kuzmenko, www.ibase.ru ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
