Hi, all I use SQLite in iOS. I found that SQLite will take lower performancein multi-thread SELECTing. Here is my test result, It costs 0.11s to select 100,0000 elements,in 1-thread SELECTing: But the sameIn 4-thread SELECTing, it costs 0.2s avg.
This test run on iPhone 6s. You can see that 4-thread is take almost twice slower than 1-thread. I know multi-thread might costs the system resource, but this result is much slower than what I excepted. Is there some race condition in SQLite or I write the wrong code ? Source Code for this test case is in the attachment.
