ExecuteSQL best practices:
Commit before SQL. FM calc engine is also slowed down with uncommitted records, not just ExecuteSQL. Just usually not as evident, because the data set is typically smaller.#DeveloperPanel#FileMakerDevCon #FileMakerDevCon18— Shawn A. Krueger (@MacGeek27) August 8, 2018