Firebird – 1 terabyte database tests and performance report

We have made 1 terabyte database test with Firebird 2.1. Read more. Questions?

Summary
In this experiment Firebird shows the following results

Undoubted ability to handle big databases. We are pretty sure that it’s possible to create and use 32 Tb database on appropriate hardware, and Firebird will show the same high performance as it shows for smaller databases (i.e., 1Tb and below).

Good scalability and amazingly small footprint. 1Tb database was created at usual desktop computer and, more important, it can be used to perform general queries: if you don’t fetch millions of records, query’s speed is the same as it is for moderate size databases (10-15Gb).

Firebird – query to show which fields in your database are not based on a domain

Our strategy is that in all of our InterBase and Firebird databases, the column definitions are based on domains.

But some of our databases do not have that for all columns (usually because we got involved later in the development cycle).

When you forget to define a column based on a domain, then both InterBase and Firebird will create a new system domain on the fly that starts with ‘RDB$’.
So if you forget, you get a new system domain for every column!

The below query will list those columns.

Firebird 1TB Database

When Dmitry Kuzmenko (IBSurgeon) spoke at FDD a few weeks ago, he shown the results of his recent tests creating a 1 TB (yes, ONE TERABYTE) database with Firebird!

It was really cool to know that FB can handle such beast! A more detailed report about this will be public available in August. Keep checking FirebirdNews!

The Firebird 2.1 Language Reference Update is now online

The Firebird 2.1 Language Reference Update is now online at

http://www.firebirdsql.org/refdocs/langrefupd21.html

The PDF failed to build with tons of errors. I’ve got no time
to investigate the problem now; leaving for France tomorrow
morning. If somebody else wants to have a shot at it, please
do. The CVS sources are up-to-date.

What roles is user able to use?

About a month ago there was a question in Firebird (CZ) group how to find whether the user is able to use particular role or to get all roles for user.

As you probably know, a lot of stuff (almost everything) is in system catalog (system tables). The only problem is to figure out what’s the right set of parameters to use. To get all roles with users able to use it, you can use …

FB/Java plugin Milestone 1 (Firebird External engine )

I’m pleased to announce availability of the first test version of
FB/Java plugin.

FB/Java is a plugin for FB external engines feature, to be presented in
v3.0, that allows execution of Java code at the server side. The plugin
allows classes/resources in the file system or stored in the database.
File system classes/resources are global and the code run with all
permissions. Database classes/resources are per-database and code runs
accordingly with per-engine configured security policy.

Also it seems that is quite fast from Adriano’s tweets

1 42 43 44 45 46 84