Go to card has become slow

Terence Heaford theaford at btinternet.com
Sun Apr 5 03:07:33 EDT 2020

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


> On 3 Apr 2020, at 17:00, Bob Sneidar via use-livecode <use-livecode at 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

More information about the use-livecode mailing list