On 2 Nov 2015, at 2:19am, sanhua.zh <sanhua.zh at foxmail.com> wrote:
> it seems that this mail list will filter my code. I re-send it now. > It?s written by Objective-C and C, but it?s quite simple to understand. There's nothing wrong with your code. Well actually there is (you don't test the values returned by all the SQLite calls) but that will not affect what we're discussing. Please compare times taken by your program when you use 'WAL' mode vs. using 'DELETE' mode. Simon.