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 On Apr 3, 2020, at 1:42 AM, Mark Waddingham via use-livecode <use-livecode@lists.runrev.com<mailto:use-livecode@lists.runrev.com>> wrote: On 2020-04-03 09:25, Terence Heaford via use-livecode wrote: Fortunately I have Time Machine running on my mac. I have gone back to a previous copy from the 01 April 2020 and this project is running at full speed. I have made no modifications to the underlying functionality of this project other than some modifications to SQLite scripts to improve performance. I will make those adjustments again and report on the outcome. I do not believe it’s anything I have done. I'd humbly suggest that modifications to SQLite scripts constitute modifications ;) Have you modified the SQLite database in any way? Like most db's SQLite is heavily dependent on indices to prevent operations being slow - if some have been removed which existing queries relied upon, or one hasn't been added to support a new/modified query then that could cause a heavy performance loss. Similarly, SQLite is transactional, so if you do lots of mutation queries outside of one each individual query will take a lot longer (as each will be under its own transaction requiring a OS disk flush/sync after each) - if you've tweaked how you are doing such queries and not taken into account transactions that could also cause a heavy performance loss. Warmest Regards, Mark. -- Mark Waddingham ~ m...@livecode.com<mailto:m...@livecode.com> ~ http://www.livecode.com/ LiveCode: Everyone can create apps _______________________________________________ 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
