During my performance tests I found out the the SQLite version which Apple provides on the iPhone 3.0 is significantly faster then my self compiled amalgamation SQLite version. So my question is, is there a way to find out which compilation options Apple did use?
Is there a test app which prints out all the default set pragams and sqlite3_config setting?
THere is no way to ask libsqlite for its exact configuration short of trying all the possible permutations and testing each to see which behaves the same (unless Apple has made custom modifications). The best you can get to call sqlite3_libversion which returns sqlite's version number.
It looks like the only different in the pragma settings is the cache_size which is default 2000 but on the iPhone it is 500.
On some systems it's possible to get read the compiler setting with this: objdump --full-contents --section .GCC.command.line