Hello Kurt, The size increase is because you're including code IN the program instead of having it in a DLL. That's one of the benefits of DLLs. The second thing, the build time thing is because you've chosen to build SQLite each and every time you build the entire project. That's purely a design choice in how you build. It's how I do it too. Your other option is to make Sqlite it's own project and only build it when it changes but, link it in by manually adding the lib path and lib name to the linker.
I have some projects I build every time when doing a release, like SQlite and I have some projects like OpenSLL where I build once and only reference the lib. I find that SQlite builds very quickly. Takes about 20 seconds in release 64 bits with full optimization. I could make it faster if I turned on pre-compiled headers but, it doesn't seem worth the effort. During development, it only build when it changes. Perhaps you only have one project and you've lumped everything together? I'd break SQlite out into it's own project then use project dependencies to make the linker include it. C Thursday, December 17, 2009, 9:01:04 AM, you wrote: KDK> Hi all, KDK> KDK> Since we're moving our project over from flat-files to an SQL DB, I've KDK> noticed that projects that utilize SQLite3 have increased to over 500k KDK> in size. Their original sizes were between 50-100k. Also, the build KDK> times have increased dramatically. I have SQLite added as a separate KDK> project in my solution (Visual Studio 2008) and have its Configuration KDK> Type as .lib. If I set it to .dll, then the rest of the projects fail to KDK> link properly stating: KDK> 1>>LINK : fatal error LNK1181: cannot open input file KDK> '..\release\sqlite.lib' KDK> KDK> I'm curious to know if this is normal behavior and if SQLite must be KDK> compiled as a .lib as opposed to a .dll? The odd thing is, I have other KDK> projects in the solution that are set to compile as a .dll and they link KDK> fine with each other. KDK> KDK> Relevant information: KDK> KDK> Visual Studio 2008 Professional KDK> Compiling as Release KDK> KDK> Let me know if you need more information. KDK> KDK> Thanks, KDK> KDK> Kurt KDK> _______________________________________________ KDK> sqlite-users mailing list KDK> sqlite-users@sqlite.org KDK> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
