On 9 Oct 2015, at 1:46pm, sanhua.zh <sanhua.zh at foxmail.com> wrote:
> It?s a mistake ofexpression. > I mean, > 1. readconcurrently indifferent threads. > or > 2. write in one thread andread inother threads. Okay. That is what WAL mode does very well. There's nothing better you can do for this than to use WAL mode. Once you have decided to use WAL mode there are other settings you can change, but they are mostly just decisions about which you value most: speed or safety. If you demand that your database is very robust and will resist corruption, then you cannot have very fast speed as well. iOS phones are extremely fast. Unless you have already written your program and found it is too slow, you may be worrying about this problem unnecessarily. The normal guidance for SQLite programmers is to first write their application without using any special PRAGMAs and then to see how fast it is. Simon.
