Ask the Expert

Can Firebird be used as an enterprise database?

Firebird has stored procedures and triggers, just like the new MySQL 5 is going to have, right? Any reason not to consider Firebird an enterprise database?

    Requires Free Membership to View

Like any enterprise decision, it's all about performance, scale and reliability. You should assess the transaction rates you expect from the database, the number of concurrent users and the availability constraints you expect to put on it.

Firebird is a smaller database server. It's not designed for applications where there are hundreds of concurrent users, or where data entry rates are very high. It also lacks a "hot backup" facility that can run without undue impact on users.

However, many corporate databases are not very large in size, and in such situations an Oracle or a Sybase might be overkill. If you have a lot of data (Gigabytes) with only a few users, like a decision support system, or less data than that and only a score of users, then Firebird may suit you very well. It operates best when you build the hardware underneath it with RAID or kernel level redundancy in disk access. You want to do backups rarely, or else be able to do them overnight.

This was first published in April 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: