Re: [sqlite] DLL Size differences and other info requested

2013-07-04 Thread James K. Lowden
On Thu, 4 Jul 2013 17:36:37 +0200 Philip Bennefall wrote: > Do you have any views on compiling SqLite optimized for speed rather > than size? These days, size is speed. The smaller the code, the better it fits in cache, the faster it runs. The days of unrolling loops to avoid branches in the p

Re: [sqlite] DLL Size differences and other info requested

2013-07-04 Thread Simon Slavin
On 4 Jul 2013, at 4:36pm, Philip Bennefall wrote: > Thanks for that info. Do you have any views on compiling SqLite optimized for > speed rather than size? Is the difference in performance generally small > enough to be ignored? I am using Vc++ 2010 express and have been optimizing > for spee

Re: [sqlite] DLL Size differences and other info requested

2013-07-04 Thread Philip Bennefall
- Original Message - From: "Dan Kennedy" To: Sent: Thursday, July 04, 2013 5:12 PM Subject: Re: [sqlite] DLL Size differences and other info requested On 07/04/2013 05:49 AM, Philip Bennefall wrote: Hi Stephen, I don't know what compiler is used to build the official

Re: [sqlite] DLL Size differences and other info requested

2013-07-04 Thread Dan Kennedy
On 07/04/2013 05:49 AM, Philip Bennefall wrote: Hi Stephen, I don't know what compiler is used to build the official SqLite dll, but provided it is some version of Vc++ my experience is that MinGw often produces larger and sometimes significantly slower binaries on Windows than VC++ does. In

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/07/13 16:38, Stephen Chrzanowski wrote: > I just reduced my built file size to BELOW what comes "out of the box" > from sqlite.org. I've turned off all optimizations and ran a full > build. I'm now sitting at the 599k mark. You probably want -

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread Fehmi Noyan ISI
huge) From: Stephen Chrzanowski To: Fehmi Noyan ISI ; General Discussion of SQLite Database Sent: Thursday, July 4, 2013 9:08 AM Subject: Re: [sqlite] DLL Size differences and other info requested I just reduced my built file size to BELOW what comes "out of the box" f

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread Stephen Chrzanowski
I just reduced my built file size to BELOW what comes "out of the box" from sqlite.org. I've turned off all optimizations and ran a full build. I'm now sitting at the 599k mark. So, the next process I'm going to have to come up with some testing to validate whether optimizations should be turned

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread Stephen Chrzanowski
n Chrzanowski > To: rsm...@rsweb.co.za; General Discussion of SQLite Database < > sqlite-users@sqlite.org> > Sent: Thursday, July 4, 2013 8:29 AM > Subject: Re: [sqlite] DLL Size differences and other info requested > > > That link certainly helps. I'll poke at '

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread Fehmi Noyan ISI
ze significantly in some cases. From: Stephen Chrzanowski To: rsm...@rsweb.co.za; General Discussion of SQLite Database Sent: Thursday, July 4, 2013 8:29 AM Subject: Re: [sqlite] DLL Size differences and other info requested That link certainly helps.  I'll poke at &#

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread Stephen Chrzanowski
That link certainly helps. I'll poke at 'em. On Wed, Jul 3, 2013 at 6:53 PM, RSmith wrote: > Simply manipulating the compile-time options will create widely differing > sizes. You can exclude older support items etc. > A good overview of the compile-time options are given on the SQLite site. >

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread RSmith
Simply manipulating the compile-time options will create widely differing sizes. You can exclude older support items etc. A good overview of the compile-time options are given on the SQLite site. (Ok I'll stop being lazy and find you the actual link) http://www.sqlite.org/compile.html There, go

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread Philip Bennefall
From: "Stephen Chrzanowski" To: "General Discussion of SQLite Database" Sent: Thursday, July 04, 2013 12:37 AM Subject: [sqlite] DLL Size differences and other info requested Just for kicks because I wanted to learn "how it was done", I decided to download the

[sqlite] DLL Size differences and other info requested

2013-07-03 Thread Stephen Chrzanowski
Just for kicks because I wanted to learn "how it was done", I decided to download the amalgamation code and compile to a Win32 DLL. The secondary purpose of my doing so was that I also wanted to write a 3rd party app that'd export all headers of the amalgamation to a different format that I can th