Re: [sqlite] [Question] Does it necessary to sync directory on persist journal mode?

2012-09-11 Thread Yongiljang
Thank you for your answer! When I tested it on my Ubuntu server at the office, Performace was improved slightly. I don't remember that values exactly, but improved ratio was about 5~8%. Sys time was decreased a lot. Strace result shows almost same call counts because of osAccess call. Test SQL

[sqlite] SIGBUS error in case of disk full with WAL mode

2012-03-08 Thread Yongiljang
Dear all, I'm an android developer in charge of sqlite database. Some days ago, I'd got a SIGBUS error from sqlite when there is no space in current partition and WAL journal mode is used. This error was occurred from memset function in libc that was called by libsqlite and debugging