Subject | firebird performance on a thumb drive |
---|---|
Author | Adam |
Post date | 2005-05-06T06:29:53Z |
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
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