Subject RE: [Firebird-general] Samsung Unveils SSD Delivering Speeds of Over 2 GB/s
Author Leyne, Sean
Marius,

> It can be good for database servers with these specs :
>
> With a PCIe 2.0 interface, the SM951 has sequential speeds up to 1,600MB/s
> read and 1,350MB/s write and random performance of 130,000 IOPS read
> and 85,000 IOPS write.

The device capabilities would be lost for 99.99% of Firebird installs (depending on pricing perhaps a waste of money).

The Firebird engine has very limited ability to generate activity more than 35% of the device's potential.

We have an install with a 200GB database with 200 active database connections that is working "very nicely thank you" on a storage system which has a Random 4KB Write IO limit of 26,000 IO/s (with no controller cache)

Further, given the specs outlined in the article, I am not sure that the device would be appropriate for database servers. The use of MLC NAND would require the device to be manually provisioned (reducing disk size, to make more flash cells available) to provide protection against flash write "fade". It is also missing data-loss protection circuitry (mainly capacitors) which would preserve write data in the case of sudden power loss, which could otherwise result of file corruption.

But it would certainly be fun to have in a portable!


Sean