Re: [sqlite] Minimize sqlite3.o size

2011-07-12 Thread Richard Hipp
On Tue, Jul 12, 2011 at 10:48 AM, Baruch Burstein wrote: > These do not work with the amalgamation. How do I use these? > Some will, some won't. To use those that won't, you'll need to rebuild the SQLite amalgamation with the options you want to use and import that new amalagmation into the Foss

Re: [sqlite] Minimize sqlite3.o size

2011-07-12 Thread Michael Stephenson
o: General Discussion of SQLite Database Subject: Re: [sqlite] Minimize sqlite3.o size These do not work with the amalgamation. How do I use these? On Tue, Jul 12, 2011 at 5:44 PM, Richard Hipp wrote: > Here are some additional options you might try to minimize the SQLite >

Re: [sqlite] Minimize sqlite3.o size

2011-07-12 Thread Baruch Burstein
These do not work with the amalgamation. How do I use these? On Tue, Jul 12, 2011 at 5:44 PM, Richard Hipp wrote: > Here are some additional options you might try to minimize the SQLite size > in Fossil: > > SQLITE_OMIT_ANALYZE > SQLITE_OMIT_AUTOMATIC_INDEX > SQLITE_OMIT_AUTOVACUUM > SQLITE_OMIT

Re: [sqlite] Minimize sqlite3.o size

2011-07-12 Thread Richard Hipp
Here are some additional options you might try to minimize the SQLite size in Fossil: SQLITE_OMIT_ANALYZE SQLITE_OMIT_AUTOMATIC_INDEX SQLITE_OMIT_AUTOVACUUM SQLITE_OMIT_BUILTIN_TEST SQLITE_OMIT_DEPRECATED SQLITE_OMIT_GET_TABLE SQLITE_OMIT_INCRBLOB SQLITE_OMIT_SHARED_CACHE SQLITE_OMIT_UTF16 SQLITE_

Re: [sqlite] Minimize sqlite3.o size

2011-07-12 Thread Baruch Burstein
Yes I know (although I only got a 200k difference), but -O3 is about twice as fast in my tests. On Tue, Jul 12, 2011 at 4:22 PM, Stephan Beal wrote: > On Tue, Jul 12, 2011 at 3:10 PM, Baruch Burstein >wrote: > > > I assume this is the same for sqlite3.dll or sqlite3.lib, but if not, I > am > >

Re: [sqlite] Minimize sqlite3.o size

2011-07-12 Thread Stephan Beal
On Tue, Jul 12, 2011 at 3:10 PM, Baruch Burstein wrote: > I assume this is the same for sqlite3.dll or sqlite3.lib, but if not, I am > interested in sqlite3.o (mingw32). > How can I minimize the size of the library (compiling with -O3, since speed > is my top concern, so different optimizations is

Re: [sqlite] Minimize sqlite3.o size

2011-07-12 Thread Black, Michael (IS)
anced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Baruch Burstein [bmburst...@gmail.com] Sent: Tuesday, July 12, 2011 8:10 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Minimize sqlite3.o si

Re: [sqlite] Minimize sqlite3.o size

2011-07-12 Thread Pavel Ivanov
http://www.sqlite.org/compile.html#omitfeatures Make sure you read all important notes and tested your app thoroughly. Pavel On Tue, Jul 12, 2011 at 9:10 AM, Baruch Burstein wrote: > I assume this is the same for sqlite3.dll or sqlite3.lib, but if not, I am > interested in sqlite3.o (mingw32)

[sqlite] Minimize sqlite3.o size

2011-07-12 Thread Baruch Burstein
I assume this is the same for sqlite3.dll or sqlite3.lib, but if not, I am interested in sqlite3.o (mingw32). How can I minimize the size of the library (compiling with -O3, since speed is my top concern, so different optimizations is not an option)? If I know there are parts of SQL I don't need in