Hi,

I am currently using sqlite on an ext3 file system with ordered mode.
But we have serious performance issues when sqlite calls fsync,
especially on RAID devices.

We noticed that disabling fsync in sqlite OR removing ordered mode
solves this performance issue.

But I couldn't find if there is a risk of corrupted database in one of
these solutions.

in http://www.sqlite.org/howtocorrupt.html 3.2, I read that disabling
sync is risky if the system reorder writes. 
So can I assume that :
- I can safely disable sqlite syncs in ext3 ordered mode ?
- I can safely store my databases on an axt3 filesystem without ordered
mode if I keep sqlite syncs ?


Best regards,
Sebastien.


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to