Ram Drive involve a context switch(from user to Kernel) and hence there is loss of performance!!! Check this factor also.
regards ragha ****************************************************************************************** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! ***************************************************************************************** ----- Original Message ----- From: John Stanton <[EMAIL PROTECTED]> Date: Friday, November 9, 2007 7:02 pm Subject: Re: [sqlite] Disk caching impacts performance. > 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] > -------------------------------------------------------------------- > --------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
