Wednesday, September 20, 2006

Migrating from MS SQL

David Burton started series of articles about migration from MS SQL to Firebird.

There is also "MS SQL to Firebird Migration Guide" at documentation page.

Monday, September 18, 2006

Names identity

I found that Google Alerts is sometimes useless. During 3 weeks I tried to monitor news & web about Delphi, Firebird and Interbase, and the only news I've got were about Delphi Corp. (auto-parts company), Firebird tale and Stravinsky's music, and some protocol named "interbase".

This is interesting at least because those keywords in their wanted meaning (IDE, RDBMS) can easily be found by Google search right on first results page. If you have some positive experience about Google Alert, please tell me :-)

p.s. Oh, right now got the first real alert -

Friday, September 01, 2006

Overloaded by transactions

Do you remember old InterBase 5.6 bug when maximum number of transactions in database is depending on page size ?
Strange, but early InterBase 6.0 versions have the same, sure. Yesterday we got database with the same sympthoms, but this is ODS 10.0 database with dialect 3, created with InterBase 6.0. Let's look at statistics from IBAnalyst:

Sorry about numbers format, if it is hard to read - there are 534 million transactions in database. Since January 2005. And, if this database was put into production right after creation (or restore), there are 880 thousands transactions each day.
Why I was so impressed? This works on WinXP.
While database exists 607 days (more than 1.5 years), transaction inventory page became very big - 130 megabytes (Next transaction div 4 bytes). Database size is 160 megabytes, with the only 13 megabytes data in it.