Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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: >

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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: >

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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,

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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 >

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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 > > >

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

> 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

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

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