In the event of performance issues, use the Show and Save SQL options in Path to show the underlying SQL queries for each RUN call.
Use other tools to review the queries and investigate their performance.
For best results, use tactical database connections.