Quick Start Guide to index optimisation
Below a five point Quick Start Guide to index optimisation, courtesy of Pavel Cisar.
Author: mariuz
http://wiki.ubuntu.com/Mariuz
Core changes:plugin manager merged in trunk , stored procedures speedup in 2.5.1
Dimitry fixed one bug with stored procedures slowdown in some cases :Tuned the code a little in order to avoid redundant retrievals. As a side effect, it downgrades three-way joins to two-way ones, thus helping the optimizer to choose a good plan in the worst (zero selectivity) cases. This should resolve CORE-2933 (Very slow execution of a script that creates a lot of metadata) and CORE-3237 (Slow compilation of stored procedures) without tweaking the optimizer constants.
New plugin manager was committed to trunk. Use it for all types of plugins.
Alex Peshkoff Fixed binary packages build. No more CS/SS difference. No more linux RPMs on SF (now they are created on each distro anyway)
Another interesting bug fixed in the future 2.5.1 is CORE-2756 :substring from timestamp – unexpected result
crypt-o software powered by firebird
While on firebird-architect there was a serious discussion about encryption i found on the web the following software that uses firebird
Crypt-o will help you to organize and store securely any kind of valuable information, such as logins, passwords, customers or employees lists, access codes, credit card numbers, PIN codes, files, etc.
Crypt-o is a secure Client/Server solution for creating custom databases, which is designed for use in enterprise networks. The data is reliably stored in Firebird SQL Server database and is encrypted using AES encryption algorithm with 256-bit key. Crypt-o client applications access the Crypt-o Server using secure SSL connection.
Pictures from Firebird course
Kelver Merlotti posted (a few moths already) about the Firebird course and took pictures of one happy event:
Good morning! Saturday was a party in the course of # Firebird, to celebrate my birthday
Really nice guys! Following pictures:
Relax, firebirdsql.org main website is back online
Now you can access the main website , we hope that is faster now 🙂
django-firebird switched for #django 1.2/1.3 support only in svn trunk
The django-firebird trunk was updated with new version. It supports django 1.2 and I hope what support the next 1.3 release too.
I was using this version on production web app and all work fine for
now.[ED:also firebirdsql.ro works ok with it]
The prior django-firebird implementation with support for django 1.1 was tagged
Please, feel free to check it out and report any issue.
Any feedback is wellcome.
Firebird 2.1.3 #HDD vs #SSD Benchmarks
The forum post with the results are in Spanish but here are the results and translation in English:
1. The computer was as below :
2. Hard Drives :
a. Western Digital 1TB 64MB Cache Sata III Black
b. Crucial 128GB RealSSD C300
The test consisted in the creation of a database with 1 table :
CREATE TABLE COR_PRUEBA (
INTEGER INTEGER NOT NULL,
CHARACTER CHAR (20),
CARACTER2 CHAR (10),
“DOUBLE” DECIMAL (15, 2),
INTEGER1 INTEGER);
ALTER TABLE COR_PRUEBA
PK_COR_PRUEBA ADD CONSTRAINT PRIMARY KEY (INT);
The test is done with the IBExpert 2009.08.19 and consisted of the insertion of 500,000 records (Insert operations) with random data.
Results:
Disc A (HDD): 1hr 11m 40s 43ms
Disc B (SSD): 3m 42s 224ms
What really stunned me was the Big difference and both tests were performed with exactly the same parameters.
Judge yourself whether it is worth mounting a SSD for storage xD.
Firebirdsql website down – do not panic
Please do not panic , the line upgrade went wrong so it will be soon fixed
Message from Helen :
>I will put SQL script into rabbit hole tomorrow (provided WEB server
>will be alife). Currently non of new/old IPs do not ping.Message from Sean indicates things went wrong with the migration to the new subnet of the hosting provider. The current situation is that the Tracker is up, while the webserver is not serving pages. Can’t give more info at present as Sean is not at his desk today.
Firebird Web/Tracker may be unavailable on Wednesday January 12
Leyne, Sean announced on firebird-support list:
The company hosting the Firebird servers is migrating to a higher speed net
connection, which will require a change to the IP addresses. This means that
the addresses of the Firebird servers will also be changing.
Tips : create/alter/drop user in firebird 2.5 , or howto get rid of gsec
On .net provider list Rick Roen is writing a utility to change user password , the best way to change it is from sql :).
Read the user create/delete/update notes.
Now a regular user can change it’s own password without the need for sysdba intervention:
The new DDL command ALTER USER enables an “ordinary” user (a regular Firebird user, a non-root user on POSIX or a trusted user on a Windows system where trusted authentication is enabled) the ability to change his or her password and/or personal name elements, while logged in to any database.