Firebird has no limit. But Windows Sockets. http://www.firebirdfaq.org/faq292/
Von: [email protected] [mailto:[email protected]] Gesendet: Mittwoch, 19. Februar 2020 08:18 An: [email protected] Betreff: [firebird-support] Scalability of connection numbers of client-server solution with Firebird 3.0? Hi! I have set of Delphi applications that uses IBX and Zeos for connecting to Firebird 3.0 server. Some are direct client-server solutions (i.e. Delphi application uses IBX or Zeos components to open connection on the Firebird server) and some are 3-tier applications which have Delphi server and Delphi client (TClientDataSet is used for communication), but this server again uses IBX and Zeos. Just wanted to know - can there be any scalability issues. Currently we have some 30-40 concurrent connections, but their number can grow to 80, I guess - no more than 100. I remember from old days (back to ~2006, Firebird 1.0/Interbase 6.0/Firebird 1.5 times) that the high number of DB connections (around 50 and more) could hurt performance very much and very little could be done. Just wanted to check the current situation? Other databases have similar restrictions on the number of connections https://stackoverflow.com/questions/3733688/database-concurrent-connections-in-regard-to-web-http-requests-and-scalability and I wonder what is the best practice for Firebird with Delphi? The usual architecture for my client-server Delphi application is that I have one TIBDatabase and/or TZConnection per Delphi application and that is why MON$ATTACHMENTS usually show 1-2 attachments for each user. I guees - this is correct and I can simply can not make more optimization here - application should have 1-2 connection and there can not be any more pooling-type optimization here, am I right? For the 3-tier applications I have 1-2 connections for TDataModule and each TDataModule servers one user and those TDataModules are pooled with their connections preserved. Ususally I have 20-30 connections from my 3-tier application. Recently we increase the number of users/connections (as I said - to 50-80) and I am worrying now what can happen, should I be ready for emergence of some concerns? Just wanted to be prepared. And generally: - what are the limits on the number of Firebird connections/attachments? Should I be concerned about those limits if we will not have more than 100-150 Firebird connections? - what are pooling options for Firebird or Yii PHP application? Usually I think that pooling is very complex issue but maybe it is not? thx J.L. ub.unitel GmbH, Schulstraße 16, 06792 Sandersdorf-Brehna Geschaeftsfuehrung Klaus Richter, Olaf Meyer Amtsgericht Stendal HRB 26389 FA Bitterfeld Steuernr. 116/107/08597 Ust.identNr. DE815796778 Deutsche Bank IBAN DE53 86070024 0 6143234 00 Kreissparkasse Anhalt-Bitterfeld IBAN DE69 80053722 0 3050326 82 _____________________________________________________________________ Dieses E-Mail ist nur für den Empfänger bestimmt, an den es gerichtet ist und kann vertrauliches bzw. unter das Berufsgeheimnis fallendes Material enthalten. Jegliche darin enthaltene Ansicht oder Meinungs- äußerung ist die des Autors und stellt nicht notwendigerweise die Ansicht oder Meinung von ub.unitel GmbH dar. Sind Sie nicht der Empfänger, so haben Sie diese E-Mail irrtümlich erhalten und jegliche Verwendung, Veröffentlichung, Weiterleitung, Abschrift oder jeglicher Druck dieser E-Mail ist strengstens untersagt. _____________________________________________________________________
