Jaybird updated

Jaybird 2.1.3 released. This release fixes only one bug, JDBC-106, which is related to the situation when developers use DatabaseMetaData class with identifiers/patterns with case different to the one in the database.

The solution is to try to execute the query with the original case and when nothing is found, another query with uppercased identifiers is executed. This, in worst case will cause two queries to be executed against the database, which can lead to performance loss.

RAID 10 performance tradeoffs and firebird

I have been configuring a fair number of Linux database servers for a line-of-business application; it runs the Firebird SQL database in server mode only (no application code at all – just DB).

All of these are the wonderful Dell PowerEdge 2950 units with the PERC6i RAID controller, and my typical configuration is 6x 146G 15k SAS drives. These are the highest-performance, highest capacity solution in 3.5″ drives.

1 2 3 4 6