Subject firebird performance on a thumb drive
Author Adam
Hi Group,

I just made a small change in our application so it can run in
embedded mode and it seems (so far) to be working a treat.

But my mind went to work on the performance implications of running
Firebird on a solid state device. My hard drive has a read speed of
around 40MB/s and a seek time of around 13ms. I imagine for a thumb
drive, the transfer speed is limited largely by the USB interface, but
largely under 10MB/s. In fact on a USB1 system it is probably under
0.5 MB/s. Obviously seek time doesn't have the same meaning with solid
state, but there is a start up delay.

I am interested in your experience of the performance impacts running
off a thumb drive. We do not do a lot of data pumping, so I doubt the
interface speed will be too painful, but I do not know how the "seek
time" (for lack of a better word) compares.

Thanks

Adam