Go to card has become slow

Bob Sneidar bobsneidar at iotecdigital.com
Sun Apr 5 11:52:28 EDT 2020


Thanks Terry I did the same thing. The focus is on server performance, not client. What I gleaned is that for an individual transaction, the difference between a transactional select statement and non is indistinguishable to the end user. 

Also, filtering out any save operations (including those occurring in plugins) increased performance on Windows by an astounding amount. While queries still take 3 to 4 times as long on Windows as they do on Mac, the lag has become acceptable and comparable to other apps doing similar operations. 

I have always wondered why Windows apps that access databases seem to take so long to start up. I think I know now. 

Bob S


> On Apr 5, 2020, at 12:07 AM, Terence Heaford via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> 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
>> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



More information about the use-livecode mailing list