Subject | Re: Simultaneous Connections |
---|---|
Author | jackdmason |
Post date | 2013-01-25T21:04:48Z |
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.
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?
> >
>