Way to find out which Compilation Options were used to build SQLite

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

You can use the compile_options pragma (or the related functions as mentioned in the linked documentation) to view the compile-time options that were used when building SQLite. However, the availability of this pragma (and the related functions) seems to depend on whether it was enabled at compile-time or not. The SQLite documentation says:

Support for the diagnostic functions sqlite3_compileoption_used() and sqlite3_compileoption_get() may be omitted by specifying the SQLITE_OMIT_COMPILEOPTION_DIAGS option at compile time.

So it is likely that your distribution did not enable this feature at compile time, which means you may not be able to view the options.

Category:iphone Time:2009-05-19 Views:1

Related post

  • Run time determination of compilation options 2010-03-02

    I need to be able to determine at run time what compilation options were use to build the executable. Is there a way to do this? EDIT: I'm particularly interested in detecting optimization settings. The reason is that I'm writing commercial software

  • Which compilation option should be set for profiling? 2009-05-05

    I need to profile an application compiled with intel's compiler via VC++. I'm using VTune to profile my code. My understanding is that in release mode I won't have the debug information that is necessary for the profiler to profile my code while in d

  • how to use this flex compiler option copy non embeded files to destination folder 2009-07-20

    i am using mxmlc for building the flex projects using ant.how to use flex builder-> copy non embeded files to destination folder compiler option in ANT --------------Solutions------------- I'm not sure if this will help you out but when you check

  • Controlling compiler options in Eclipse 2009-10-07

    Is there a way to control the optimization level of the java compiler that Eclipse uses when building a project? Or is this question not relevant anymore, is all optimization deferred to the vm? The reason I'm asking is that I recently wrote a quick

  • Compiler options for C# project 2009-10-16

    Where I can change compiler options for C# project in VisualStudio 2008 (without command prompt). I need it to turn off optimization to compare optimized IL-code and unoptimized IL-code. --------------Solutions------------- [Right Click the Project]

  • C# compiler options - embedding manifest file 2009-11-29

    I have found that it is possible to embedd manifest file (added to resources) with Compiler option /win32manifest. I am trying to find compiler options in VS express but I cannot see it. Could you please help me? Thanks --------------Solutions-------

  • File-specific compilation options in Visual Studio 2008 2009-12-15

    If I had a project structured like this... a.cpp b.cpp c.cpp ...and I wanted to compile a.cpp and b.cpp with one set of compiler options, and c.cpp with another set, how would I do that? --------------Solutions------------- I think the easiest way wo

  • Xcode makefile or compilation options 2010-01-19

    I am new to Xcode. Once I configure my C++ command line application to build, and it builds successfully, I have sometimes no clue about how Xcode calls GNU C++. Is it possible to get the makefile that Xcode creates or how to see the compilation opti

  • Compile options to suppress GCC warnings from other people's header files? 2010-01-28

    gcc 4.4.2 I am using these compile options in my Makefile. And my application links to several 3rd party libraries. -ggdb -Wall -Wextra -pedantic -std=c89 However, the pedantic is displaying many warning for the 3rd party libraries. I am wondering ho

  • How to declare compile options as valid symbols in Flex under IntelliJ IDEA? 2010-02-23

    I've got the following Flex code in an MXML file: <mx:Label id="lblVersion" styleName="versionID" bottom="0" right="10" text="Version { BUILD::version }"/> where the "BUILD::version" is meant to be substituted from symbols defined in compiler o

  • Automatically find compiler options for fastest exe on given machine? 2010-03-14

    Is there a method to automatically find the best compiler options (on a given machine), which result in the fastest possible executable? Naturally, I use g++ -O3, but there are additional flags that may make the code run faster, e.g. -ffast-math and

  • VS 2008 Compiler option for flagging uninitialized variables 2010-03-30

    Is there a compiler option in VS 2008 (C++) to expose uninitialized variables? I'm trying to debug a problem where the "release" build of a DLL does not work but the "debug" build of the DLL does work. --------------Solutions------------- iirc, setti

  • xcode compile options 2010-04-25

    I am compiling from the command line with gcc -o output-file $(mysql_config --cflags) main.c $(mysql_config --libs) How can I add the extra params to xcode compiling options? gcc -o output-file $(mysql_config --cflags) main.c $(mysql_config --libs) -

  • How to apply different compiler options for different compilers in cmake? 2010-06-28

    I'm currently working on using cmake to build some projects, with the main platforms being Visual C++, MinGW GCC and Linux GCC. When building with GCC, I need to specify the -Wno-invalid-offsetof compiler option. My current fix is as follows... if (

  • gcc 4.3.3 compiler options enabled by default 2010-06-29

    I have moved from gcc version 4.0.3 to 4.3.3 and realized that -mfpmath was set to sse by default in gcc 4.3.3. This actually caused errors in my application. In 4.0.3 the -mfpmath was 387. I want to know how I can get all the default options enabled

  • Passing Maven Compiler Options From The Command-line 2010-07-01

    I am setting up several projects on a continuous integration server, some of which I don't have access to change the source code to, The server is a linux box, I am running into a problem where maven encoding needs to be changed to UTF8 to be able to

  • Enable C++ exceptions in Visual Studio 2010 compilation options 2010-07-21

    I'm trying to compile this source code : // exception_set_unexpected.cpp // compile with: /c /EHsc #include<exception> #include<iostream> using namespace std; void unfunction( ) { cout << "I'll be back." << endl; terminate( );

  • Visual C# - Compiler Options 2010-07-22

    I'm looking for the compiler options in Visual Studio 2010 (Visual C#). Does anyone know how I can access these? --------------Solutions------------- Right click over the project name in the solution explorer to get the Properties dialog. Select the

  • Building Perl for OS X - Architecture-Specific Compile Options 2010-09-07

    Thanks to a suggestion from Chas. Owens, I have been having fun playing with Perlbrew to have various Perl builds in my home directory. My question is more generally on building a newer Perl under OS X however. I have OS X 10.6.4 Snow Leopard running

Copyright (C) pcaskme.com, All Rights Reserved.

processed in 0.525 (s). 13 q(s)