There is an interesting debate here as to whether it is necessary or not to wrap select statements in transactions for optimisation:
https://stackoverflow.com/questions/7349189/optimizing-select-with-transaction-under-sqlite-3 <https://stackoverflow.com/questions/7349189/optimizing-select-with-transaction-under-sqlite-3> I think there is probably widespread debate about this subject. I don’t know the answer? Best regards Terry > On 3 Apr 2020, at 17:00, Bob Sneidar via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Mark, you may have answered why it is my Forms Generator app is running so > slow on Windows. I don’t use transactions and I make multiple queries for > most transactions. > > Bob S > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
