Procedure to rebuild all indexes

One comment

After reading news about rebuilding Firebird indexes, I wrote a procedure for Windows, which allows fully automatic rebuild all indexes in the Firebird database. The procedure is described on my website http://gskoczylas.rekord.pl/Firebird/AutoReindexAll.php (in Polish). Automatic translation into English is here: http://goo.gl/9Uu96.

At the end of the web page there is a link which allows to download the complete procedure. Procedure has been tested on Windows Vista with Firebird 2.5.

—
Regards,

Grzegorz Skoczylas
gskoczylas@gmail.com

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Rebuilding a Firebird index

Leave a comment

After looking at Damyan Ivanov posix script to rebuild indexes, I saw that he was using an undocumented “implementation artifact” (thanks to Dmitry Yemanov for confirming this) to rebuild indexes (including PK and FKs indexes). What he does is to call ALTER INDEX xxxx ACTIVE, where xxxx is an already active index!

Beside the fact that trying to activate an already active  index sounds “weird”, this will make Firebird to rebuild the index. Seems to be an easy way to rebuild PK/FK/UNIQs indexes (since they cannot be deactivated).

BTW, Damyan’s script will rebuild all indexes containing “text” fields in their keys. He created the script for the case where a previously created database needs to be run in a Firebird compiled with different version of the ICU libraries.

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 4.50 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 3.67 out of 5)
Loading...

New version of FreeAdhocUDF released

Leave a comment

Right to the FireBird Conference starting tomorrow in Bremen we uploaded a new version “adhoc 20101111” of FreeAdhocUDF.
There are some importend bugfixes, expanded functions, 11 new functions (totally now 551!) and new support for InterBaseXE 32 und 64bit.

This is a recommended update.
FreeAdhocUDF is the the first (and still the only?) UDF-library with UTF-8 and UNICODE-FSS support.
FreeAdhocUDF is licenced under the LGPL and you can use it without costs also in commercial projects – see licence.
You can download it from ftp://ftp.FreeAdhocUDF.org/FreeAdhocUDF/
Documentation found at http://FreeAdhocUDF.org/index_eng.html – still be updateted in the next days …
For all kind of questions and bug-reports use eMail help@freeadhocudf.org

adhoc dataservice / Christoph Theuring

1 Star2 Stars3 Stars4 Stars5 Stars (7 votes, average: 5.00 out of 5)
Loading...

The Decline of #MySQL and Rise of Firebird SQL

Leave a comment

The decline will not be immediate, it will take some time, notably Apache distributions like XAMPP and WAMP will have to offer users alternatives to MySQL, as most developers use these packages, instead of installing products independently. All is not lost, the Open Source community has plenty of options. There are two well established alternatives to MySQL: PostgreSQL and Firebird. Both have large established communities, and support of major corporations. One of these will become the next MySQL

1 Star2 Stars3 Stars4 Stars5 Stars (12 votes, average: 4.58 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Migrating users from FB 2.1 to FB 2.5

Leave a comment

People moving to FB 2.5.0 may be asking if it is safe to copy the security2.fdb file from previous versions of Firebird to Firebird 2.5, keeping the users previously created, so avoiding to recreate them.

In theory, copying the file should work, but with no guarantees. Firebird 2.5 uses a new ODS (11.2). You can do a backup/restore in FB 2.5 to update the ODS of security2.fdb, but some problems will still persists, regarding the use of the new role RDB$ADMIN (which gives SYSDBA rights to “normal” users) – in this case, normal users who were granted RDB$ADMIN role, will have problems to use the new SQL commands CREATE/ALTER/DROP USER. Note: Firebird 2.5.1 will bring a sql script to fix this problem.

So, the safest way to move users to FB 2.5 right now, is to recreate them in Firebird 2.5, either using gsec.exe or the new CREATE USER statement.

Thanks to Dmitry Yemanov for detailed information about the problem.

1 Star2 Stars3 Stars4 Stars5 Stars (8 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (8 votes, average: 3.63 out of 5)
Loading...

Wanna transaction in MySQL? Ok, pay now, or go to Firebird.

4 comments

Looks like Oracle decided to charge money for those who wants to use InnoDB with MySQL. InnoDB offers features like transaction control, not found in the “classic” version of MySQL. Read more  here and here.

Need Transactions, Stored Procedures, Triggers, etc. and don’t wanna to pay? GO FIREBIRD!

Update: As pointed by some of our readers, InnoDB is still offered for free in the MySQL “Community” edition.

1 Star2 Stars3 Stars4 Stars5 Stars (14 votes, average: 4.43 out of 5)
Loading...

1 … 225 226 227 228 229 … 485