Hello ! Again the problem was my fault, I was not checking the return code of setting "PRAGMA synchronous=0" and for some threads it was SQLITE_BUSY so they started in synchronous mode and that slowdown everything !
Sorry by the noise ! The updated program to test somehow sqlite performance with multiple concurrent connections is at https://gist.github.com/mingodad/79225c88f8dce0f174f5 . Cheers ! ?
