> We do not want to rewrite our applications to use a
>single database, that would be absurd.

Indeed it would be absurd. That's not what I suggested, instead I suggested as one option to write a middle layer, between your applications and your databases, that optimizes database connections if you think your going to have a problem. This middle layer could be either on the same pc as the application(s) or on a server. Or, write one that uses HTTP-API towards the apps to even let the apps work through firewalls etc, without having to let direct access to the DB throug the firewall. Anyway, these were just suggestions to help if you are having problems.

But now, I think you are asking this question simply because you read something in the documentation and are worried that there may be a limit on connections? Why dont you have a look at the firebird configuration file - there might be something about that in there? I don't remember and do not have one conveniently accessible now.

- Aaron

--- In firebird-php@yahoogroups.com, "jackdmason" wrote:
>
> It may not be a problem. Here is what the documentation says:
>
> Simultaneous connections
>
> Only Classic and SuperClassic allow simultaneous connections to a database from the regular server and one or more embedded servers. Thus, if you use the Windows Embedded Server, it may be advantageous to have Classic or SuperClassic as your regular server.
>
> It is not even clear to me what that means exactly. InterBase has allowed our applications to run without a limit on "simultaneous" connections. MySQL allows us apparently an unlimited number. What is Firebird limiting?
>
> We do not want to rewrite our applications to use a single database, that would be absurd. Not all applications use all databases and the size of the combination would be horrendous... and as far as I know there is still a 2GB limit on file sizes under Linux and Windows.
>
> We are simply looking to replace InterBase with Firebird and if that is not possible, then with MySQL.
>
>
> --- In firebird-php@yahoogroups.com, "slobtrot" wrote:
> >
> > Why do you need to know the exact amount of connections?
> >
> > Do you use persistent connections? If not, the amount of connections depend on how often you open/close the connection in your application.
> >
> > If you use persistent connections then:
> > 8 computers
> > opening 4 separate persistent connections
> > = 32 simultaneous connections
> >
> > Why don't you use something like wireshark to find out for yourself what goes on at the server?
> >
> > > If I have two more applications on each of those 8
> > >computers opening 2 of the same databases, is that
> > >counted as more simultaneous connections?
> >
> > I think this completely depends on how you implemented those connections in your own application.
> >
> > If this is a problem for some reason, then rewrite your apps to use one database module on each computer that optimizes the connections (e.g. only opens 1 persistent connection to each DB) and has an API that your apps call, and let the apps only call that local module instead of talking directly to the server. OR; write your own DB->HTTP-API serverside-application, and let your apps fetch data over HTTP when they need it, and have that DB-HTTP module worry about what connections to make and when etc...
> >
> >
> > --- In firebird-php@yahoogroups.com, "jackdmason" wrote:
> > >
> > > The documentation says on Classic and SuperClassic allow simultaneous connections to a database. What is that?
> > >
> > > If I have 8 computers concurrently opening 4 databases on a Firebird server, how many simultaneous connections is that?
> > >
> > > If I have two more applications on each of those 8 computers opening 2 of the same databases, is that counted as more simultaneous connections?
> > >
> >
>