Go to card has become slow

[Terence Heaford]

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 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
>