I could compile sqlite with CCC. Most of the SELECT, CREATE, UPDATE queries worked but joins seem to be stuck consuming a single core forever. GCC compiled binary just takes under 50ms for the same ...

There's a bit of a story behind this one. On Apple iOS, there is some sort of OS-level baked in auto-detection of SQLite databases to add a special case to locks that are allowed to be held when iOS ...