Subject Re: Why firebird isn't popular on the web?
Author karolbieniaszewski
--- In firebird-support@yahoogroups.com, "Ahmet Nuri D" <ahmetdenize@...> wrote:
>
> Yes, I read same documents for this subject.
> I can see two main problem for web hosting companies.
> The first problem is security architecture.
> The second problem is 3rd party tools like PhpMyAdmin. And need some components.
> Firebird is very stabil data base system.
> I believe Firebird can be best open source data base system for on the web.
>

there is one more limitation may by not last
Firebird have something like transaction counter
and this is 32 bit signed value.
This counter get progressed when you start transaction.
If you reach max value your database can not start another transaction
and your web will be down.

Of course your web must have big load to reach this limit - for medium or small load firebird in this scenario is very good.
e.g. 10 000 visitors making 100 transactions (eg. select somethink)
= 1 000 000 transaction per day
2^31 = 2147483648 / 1 000 000 = 2147 continuous work days without backup restore cycle - its big but for some scenarios can be not acceptable e.g. 100 000 visitors with 100 transactions or 10 000 visitors with 1000 transactions you get only 214 continuous work


Karol Bieniaszewski