No. The size of the object code depends on what compiler optimizations are used. Generally speaking, there is a tradeoff between size and performance. The more memory you devote to a program the faster it will run.
The following table shows the object-code size of a pre-3.3.14 version of SQLite versus the run-time for the "speed1.test" performance test in the source tree.As you can see, the size of the library ranges from 224 KiB up to 513 KiB depending on what compiler optimizations are used. The range is performance is not as drastic. But the smallest version of the library is still almost 20% slower than the fastest version. Note that the precompiled binaries available for download from the SQLite website are compiled with -O2 which gives a good balance between size and performance.
So, Yes, SQLite really does weight in at less than 250KiB when compiled with -Os. But if you want to add that extra 20% performance boost of -O3, you'll need to allow the library to more than double in size.
The above tests were run on a SuSE 10.1 system with GCC 4.1.0 using the amalgamation source file "sqlite3.c". The "-fomit-frame-pointer" option was used in every cases except the first "none" case. Other compile-time options where:
Readers are invited to run similar size versus speed studies on other compilers and operating systems and report their findings below