Find Profiler (aka Query Execution Plan or EXPLAIN PLAN-like query profiling)

Idea created by ColinKeefe on Oct 30, 2015
    Active
    Score17

    This one's a little fuzzier than Script Profiler in terms of how to visualize the information, but the need is I think evident.


    Find Profiler

    When Find Profiler is enabled (not sure where this would live), when a user performs a find, the server calls required to satisfy the request are presented to the user in a diagnostic panel, with some method of identifying what percentage of the total Find response load is attached to each Request Record and Field in the Find.

     

    This idea draws inspiration from query profiling tools in other platforms.  I'm including a screenshot for context.  How this gets modeled in FileMaker would necessarily be different.

     

    example_query.jpg