Michael Scharf wrote:
[EMAIL PROTECTED] wrote:
"Trevor Talbot" <[EMAIL PROTECTED]> wrote:
Beyond that, I'm not aware of anything that would help.
All good advice. But you left off the obvious: Get a
faster disk drive. ;-)
...which does not really help unless you buy a very expensive
flash disk drive. How much faster is a *really* fast spinning disk?
Trevo, have you tried to put your database on a (fast!) USB stick.
It should be much faster in 'seeking' but is slower in the
data transfer. This would give some indication if the access
is limited by seek or the disk reading speed.
Michael
A USB flash drive is not particularly fast due to the limited write
speed of flash memory and buss speed. A fast disk spins at 15,000 rpm,
double the speed of the higher end 7,500 rpm disks and almost 3 times
the speed of the regular 5,400 rpm devices.
If you want to simulate a disk with no latency set up a RAM drive.
There is a physical constraint here. If you want to verify that your
data is safely written to non-volatile storage you have to live with the
latency. If that is unimportant to you you can relax the ACID
requirements and get faster writes, but when you do that there is no
crying over lost data after a crash.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
