Sorry, when I saw 100-200 simultaneous connections, I immediately thought that you mean the intranet. In our applications, we participate on average 300-450 simultaneous users, so we do not consider this application based on the Internet, until you look at a possible 5000 users.
Design criteria for such a system are very different from a system with less than 1000 users.
When you come to such a system, you look at the cloud configuration. Since our company is a telecommunications company, and we are required by law to conduct a 5-9 service for our customers, we use firebird in all our processes in the background. Although we used DB2, Oracle, and other products in the past, Firebird was either more reliable or superior to others.
With the release of Firebird 2.5 (now in rc 2, if you want to play with it), you can use firebird because it is medium-level, with one database connecting to several other databases to perform DML and DDL actions. You may have one Firebird database in which there are no tables at all, only stored procedures, views, etc. This database can then process data from multiple sources without knowledge of the client application. Since the connection can be dynamically built in stored procedures, you can change the database databases as needed without changing the external interface code. This allows you to load balance, have several web servers in conjunction with one database cluster, etc.
So, since Morfik supports Firebird, I would say yes, Morfik can scale without problems in a larger environment. In terms of Firebird support, it has one of the most active user communities on the Internet.
From Morfikβs point of view, morfik is a great way to create a web interface using an existing developer base without having to learn a number of new languages. But currently, it allows the developer to use n-level development tools without interfering with them. I like this. I do not want a tool that tries to be everything and, in turn, does nothing.
Best wishes
Dalton Calford Distributel Communications