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