Hi Steven.
You're absolutely right.
Adding the sources to a real iOS project (standard Xcode 4, View-based iOS app)
results in 885 KB. Great to see the linker/stripping process remove all this
symbol info.
Thanks for the help,
-- Tito
On May 16, 2011, at 8:49 AM, Steven Parkes wrote:
>
Well, for my part, I forgot that I'm not including the R-tree stuff at this
point. I do include FTS (that's why I have a custom build, not to mention the
latest WAL stuff.)
And to the extent it matters, I'm not using LLVM.
But I am building -O0 -ggdb. That doesn't do any inline or deadcode
Hi Richard,
On May 16, 2011, at 8:40 AM, Richard Hipp wrote:
> I took the amalgamation file (sqlite3.c) and compiled it thusly:
>
> gcc -Os -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -c sqlite3.c
>
> The resulting binary size (as reported by the "size" command) is 392,203
> bytes. That's
On Mon, May 16, 2011 at 11:32 AM, Tito Ciuro wrote:
> Hi Steven,
>
> OK. First of all, I messed up by compiling shell.c (which is included in
> the SQLite amalgamated distro.) Removing it brings the size to:
>
> GCC:
> - Debug: 3.1 MB
> - Release: 3.4 MB
>
> LLVM Compiler 2.0:
>
Hi Simon,
No, I don't need it... but someone else might. I was considering adding FTS3 to
my library in case someone needs to search across several text records.
Depending on the table size, LIKE or GLOB would be very expensive because doing
a full table scan would not be the most optimal
Hi Steven,
OK. First of all, I messed up by compiling shell.c (which is included in the
SQLite amalgamated distro.) Removing it brings the size to:
GCC:
- Debug: 3.1 MB
- Release: 3.4 MB
LLVM Compiler 2.0:
- Debug: 3.7 MB
- Release: 4 MB
This is what I did:
1) Create a new project in Xcode,
On 16 mai 2011, at 17:01, Tito Ciuro wrote:
> Hello,
>
> I have a question about SQLite running on iOS. If I'm not mistaken, SQLite on
> iOS is not compiled with R*Tree and FTS3. Compiling a static library of
> SQLite's amalgamated version weighs at about 4.3 MB, which represents almost
>
On 16 May 2011, at 4:06pm, Marco Bambini wrote:
> 4.3 MB seems really too big... you are probably building a debug version of
> the library.
Agreed. I don't know what's wrong but nothing should take 4Meg.
Also, do you really need FTS3 ? Try a simple search using LIKE or GLOB. With
the
Hi Marco,
Oops. My bad. Building for Archive (Release version) has a size of 3.6 MB.
-- Tito
On May 16, 2011, at 8:06 AM, Marco Bambini wrote:
> 4.3 MB seems really too big... you are probably building a debug version of
> the library.
>
> --
> Marco Bambini
> http://www.sqlabs.com
>
>
>
> Compiling a static library of SQLite's amalgamated version weighs at about
> 4.3 MB
Where are you coming up with this number? My .a is 2792KB and that's with both
armv6 and armv7, debugging, and full symbols.
I pull in sqlite3, openssl, about a billion other things, and plenty of my own
4.3 MB seems really too big... you are probably building a debug version of the
library.
--
Marco Bambini
http://www.sqlabs.com
On May 16, 2011, at 5:01 PM, Tito Ciuro wrote:
> Hello,
>
> I have a question about SQLite running on iOS. If I'm not mistaken, SQLite on
> iOS is not compiled
Hello,
I have a question about SQLite running on iOS. If I'm not mistaken, SQLite on
iOS is not compiled with R*Tree and FTS3. Compiling a static library of
SQLite's amalgamated version weighs at about 4.3 MB, which represents almost
25% of the 20 MB-per-app allowed on the App Store. For many,
12 matches
Mail list logo