Re: [sqlite] Questions about your "Performance Matters" talk re SQLite
On 4 Jan 2020, at 5:49pm, Doug wrote: > for (i=1000; i--; i>0); If you have optimization turned on, your compiler might turn that into "i = 0". Optimization messes with a lot of benchmarks. Checking which optimization setting was used is one aspect of what Howard Chu was talking about: benchmark figures in isolation don't mean much. I'm not a big fan of general statements about which form is faster, uses less memory, whatever, than which other form. I want to say "try both ways and keep the one which is best". ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Questions about your "Performance Matters" talk re SQLite
haha, that is a mangled way of saying I wrapped my db functions in a dll for multiple app use. I did not expose this config setting as I never knew its impact. To be honest, I still don't. ;) On Fri, Jan 3, 2020 at 5:18 PM Tim Streater wrote: > On 03 Jan 2020, at 22:08, sky5walk wrote: > > > Querying the config state is helpful for a dll wrapped database, ... > > What's one of them? > > > -- > Cheers -- Tim > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Questions about your "Performance Matters" talk re SQLite
On 03 Jan 2020, at 22:08, sky5walk wrote: > Querying the config state is helpful for a dll wrapped database, ... What's one of them? -- Cheers -- Tim ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users