Yes Richard, in my experience your quoted time benefits are very much on target. I have rewritten Excel/Access (VBA) which I originally developed (and was quite proud of). Re-writes using C/C++ and SQLite indeed delivered the performance gains you experienced and relieved me of the pain associated with VBA development. A sort of win-win, and if you throw in moving away from Windoze to something sensible you can get even more benefit. But that is another tale...and sadly not always under our control.
On 19 August 2016 at 00:12, Rousselot, Richard A < richard.a.rousse...@centurylink.com> wrote: > 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 > -- Regards, Michael.j.Falconer. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
