It's official now, I'm the maintainer of Firebird packages for Fedora and Epel (Centos and RHEL packages) and Firebird packages get pushed into Fedora repositories. The good news for Firebird users is that they can get Firebird 2.1.2 from Fedora...
Last months I saw in various support lists and forum questions about lost connections and Firebird As said in firebird.conf : Normally,Firebird uses SO_KEEPALIVE socket option to keep track of active connections. If you do not like default 2-hour...
Running FirebirdCS-2.1.1.17910-0.amd64 under Linux Fedora core 9 version 2.6.27.15-78.2.23.fc9.x86_64 When thedatabase is under a high load (i.e. over 100 connections) where each connection is doing queries and updates, then merely executing select...
Yesterday I get a small nice box, a Gdium that havea 900 Mhz 64bits Loongson CPU It comes with a Mandriva Linux. I built Firebird 2.1.2 on it, the only point is that I built it with systemICU : 1./autogen.sh --with-system-icu Bingo, I get a fresh build...
May, 20th in the opensuse packaging mailing list, Michal Marek posted the following : We have a firebird (the opensource SQLdatabase) package in the server:database buildservice project...
During the test phase of Firebird 2.1, I played with two new features : global temporary table and monitoring tables. I never stressed Firebird on MacOs X before, and when I tried to do 300 concurrent connections each one using a temporary table and a...
Quelques fois il peut être utile de forcer le moteur à recalculer la sélectivité des index afin de permettre à l'optimiseur de choisir des meilleurs plans de requête et donc de faire les traitements plus rapidement Voici une procédure permettant de...
Si on utilise ISO8859_1 comme jeu de caractères, on peut choisir comment convertir en majuscule les lettres accentuées par exemple : 1 2 3 4SELECT UPPER(CAST('aeiouéèàüûôë' AS CHAR(12) CHARACTER SET ISO8859_1) )C_NP, UPPER(CAST('aeiouéèàüûôë' AS...
Il arrive quelques fois que l'on soit obliger de détecter ou supprimer desdoublons dans des tables sur un champ particulier. Cela peut devenir une opération très longue et gourmande en ressources.Heureusement on peut utiliser pour améliorer les...
Voici quelques définitions de vues système conformes à la norme SQL-92: Lister les contraintes CHECK CREATE VIEW CHECK_CONSTRAINTS (CONSTRAINT_NAME,CHECK_CLAUSE) AS SELECT RDB$CONSTRAINT_NAME, RDB$TRIGGER_SOURCE FROM RDB$CHECK_CONSTRAINTS RC,...