Category: Technical Articles

Technical articles, How-tos, guides, etc.

How to run SuperClassic on Linux

Leave a comment

Firebird 2.5 brings a new architecture called SuperClassic. The official FB 2.5 Linux packages brings SuperClassic and Classic in the same package, and when you install it, Classic will be activated by default.

To be able to change to SuperClassic, you need to run the script changeMultiConnectMode.sh that is installed with FB 2.5.

You will be prompted with: “Which option would you like to choose: multi-(process|thread) [process]”

Answering thread will activate SuperClassic, while process will activate Classic mode.

PS: This is not documented in the Release Notes.

Converting a #MySQL database to Firebird Part1 (from Lamp to Flaps)

Leave a comment

Milan Babuskov wrote on his blog about his first steps in moving one host from Mysql to Firebird

I have a heavy-used website powered by LAMP stack (CentOS Linux,
Apache 2, MySQL and PHP). It started on a shared hosting so I had to
use MySQL. Year and a half later, I switched shared, virtual hosting
and not run it on a dedicated server. I decided to try Firebird to see
how it performs and also how it compares to MySQL in RAM usage, disk
usage, etc.

gbak running in embedded mode

One comment

матрациThose who are new to the Classic version of Firebird on Linux may find interesting that, while running gbak to backup a database, accessing the DB file locally (not by tcp/ip, etc), you will not find a fb_inet_server proccess serving the gbak connection. This is because, in this specific situation, gbak works in embedded mode. Alex Peshkov says this provides the best performance results.

How to increase Firebird backup and restore speed (up to 30%)

Leave a comment

It seems that many Firebird developers and administrators are not aware about  command line switch -se[rvice] for gbak.exe

-SE[RVICE] <servicename>

This switch causes gbak to backup a remote database via the service manager. This causes the backup file to be created on the remote server, so the path format and filename must be valid on the remote server. The servicename is currently always the text service_mgr.

here is the rest of the article in Eglish

also there is an Italian mention in blogosphere

#ASP + Firebird: #VisualBasicScript, #JavaScript and #PerlScript

Leave a comment

In our example I’ll show you how to use ASP to access a Firebird database via VisualBasicScript, JavaScript and PerlScript. Although not my favorite language, ASP will serve to illustrate the example. Also note that ASP uses ADO technology to access the database. This involves several “layers” so that access occurs.
Of course this may make access a little slow, but not the object of this article. It also assumes that the reader knows the ASP technology.

1 … 26 27 28 29 30 … 78