Subject Firebird writes on Flash Disks
Author Nathan Penny

We are moving our Linux distribution to flash based disks. Our only concern with this move is the number of writes Firebird is going to do to the database on the disk. We supply systems with Firebird installed and accessed only by the local system.

We will be using Kingston Compact Flash cards, with 100,000 write cycles per physical sector. The database is generally quite small, less than 50Mb, though changes happen every couple of seconds or so.

The bulk of the OS will be in a read only filesystem, with a few logs and configuration files in a writable area. The database will also be in a writable area.

We will be using a 4Gb CF, of which less than 1Gb will be used by the OS. This leaves 3Gb for the wear leveling algorithms to play with for the logs (very small) and the database.

What sort of effect will this constant writing have on the Flash Disk? Has anyone had any experience with this? Is the writing going to be severely detrimental to the life of our CF?

Many Thanks,

Nathan Penny

[Non-text portions of this message have been removed]