Episode 30: Using ExecuteSQL: A Cautionary Tale

About this episode

The episode discusses performance issues related to ExecuteSQL in FileMaker and offers debugging and optimization tips.

One little ExecuteSQL query can’t hurt… right? In this episode, the team unpacks the FileMaker performance issues hiding inside real-world solutions. Runaway SQL calls, invisible object calculations, and AI-generated code that looked smart until it brought everything to a crawl. They discuss debugging wins, optimization tips, and the kinds of “how did this even happen?” moments that every developer eventually runs into.

People in this episode

Host: Portage Bay Solutions

Topics covered

• FileMaker
• ExecuteSQL
• performance issues
• debugging
• optimization
• AI-generated code

Keywords

• ExecuteSQL
• FileMaker
• performance
• debugging
• optimization
• AI code
• SQL calls

Mentioned in this episode

Products: ExecuteSQL

Books & works: FileMaker

More episodes of FileMaker DevCast: Everything Claris FileMaker

• Episode 31: What We’ve Been Building: Web App Edition · June 12, 2026 · 40 min
• Episode 29: Claude Cowork, AI Linguistics, and 3D Printing · April 22, 2026 · 41 min
• Episode 28: Comparing Tools: FMPerception, BaseElements, 2empowerFM · February 5, 2026 · 1h 3m
• Episode 27: Meet HAM - Another Option for FileMaker Permissions (with Charles Delfs) · December 15, 2025 · 58 min
• Episode 26: Click, Build, Deploy: FM BetterForms Updates Unwrapped · November 3, 2025 · 49 min
• Episode 25: Reports, Pickers, and JSON: The Value of Virtual Lists · September 19, 2025 · 51 min