Simon, I was only interested in doing these calculations quickly; that is my real-world. The SQL scripts I am using were built with multiple steps with intermediate temp tables that are used to create a final result table.
I understand my needs are not generally how others use SQLite. I am using it as a platform for fast calculations that happens to store results in a way that can be quarried. Every time, my process begins all prior results are deleted, only the input tables stay the same. I will pass the baton on to someone else to do more realistic, real world, testing of 32-bit vs 64-bit. Richard -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, August 17, 2016 11:09 AM To: SQLite mailing list Subject: Re: [sqlite] 64-bit SQLite3.exe On 17 Aug 2016, at 4:54pm, Rousselot, Richard A <richard.a.rousse...@centurylink.com> wrote: > PRAGMA journal_mode = Off; This configuration is designed for cases where the resulting database will be thrown away soon (e.g. when the application quits). It does increase speed greatly, but a consequence is that the benchmark is not useful as an indicator of performance in the real world. Some of your other PRAGMAs also seem to be suitable only to running benchmarks quickly. A fairer test, one more like real world performance, would be not to use any PRAGMAs at all apart from turning on FOREIGN KEYS. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users This communication is the property of CenturyLink and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
