Yes, it is much faster. The process was done in Excel/Access before and took ages. I have had processes go from 8 hours before to 30 min now using SQLite.
-----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Michael Gratton Sent: Wednesday, August 17, 2016 8:05 PM To: SQLite mailing list Subject: Re: [sqlite] 64-bit SQLite3.exe Richard, On Thu, Aug 18, 2016 at 2:23 AM, Rousselot, Richard A <richard.a.rousse...@centurylink.com> wrote: > 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. Out of curiosity, are you using these in an end-user application, i.e. as an interactive response to user actions? I would be curious to know if building intermediate temporary tables is fast enough for returning results for such uses. Thanks, //Mike -- ⊨ Michael Gratton, Percept Wrangler. ⚙ <http://mjog.vee.net/> _______________________________________________ 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
