Re: Should SQLite users be setting barrier=1?

[Dan Kennedy <danielk1977 gmail com>]

> If you do not use barriers, your storage device could very well lose  
> data if it loses power. There is no easy answer, you need to  
> understand the type and configuration of your storage.
>
> For a local SAS/S-ATA drive, you should have barriers enabled when  
> the write cache is enabled (check that with hdparm for example on S- 
> ATA). Note that you could also be safe by disabling the write cache  
> and leaving barriers off as well.
>
> If you have a non-volatile write cache (for example on an external,  
> enterprise class array), you can safely mount without barriers.
>
> Regards,
>
> Ric



Hi Ric,

Thanks very much for the quick response (and Eric, thanks
as well).

Richard put a paragraph with a link to your answer in
our documentation here:

  http://www.sqlite.org/draft/lockingv3.html#ext3-barrier-problem

Please let us know if this misrepresents the situation.
Or if there is something else we should add to clarify
it.

Thanks again,
Dan.