Author: Cantu

I'm the owner of the www.Firebase.com.br site and the author of the books Firebird Essencial, Firebird 2 and Migration Guide to Firebird 3. Loving Firebird even before it was born!

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.

Benchmark tool

2 comments

Philippe Makowski posted this at fb-devel:

Hi,

I found this bench : http://tokutek.com/products/iibench/

(http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py)

and aibench.py:
http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/aibench.py

I made a Firebird version of both. You can download them here : http://www.firebirdsql.org/download/rabbits/pmakowski/

If you find them useful, I will put them in the svn QA repository

DDL Execution Architecture

Leave a comment

Adriano posted about DDL execution artchitecture, its flaws and new improvements for FB 3.

Here I’m going to explain how Firebird DDL commands works in the architecture, why it stops innovation and how it is supposed to work in Firebird 3.0.

DDL in FB works more or less like DML, so first a briefly explanation of how DML works. When a DML command is prepared, it starts in the parser constructing a tree of nodes. That nodes are all a single pointer type, used for all node types and others usages (like storing constants). A node have a list of child nodes.

Real full post here.

1 … 31 32 33 34 35 … 100