SQL in FADA

The database schema for an application is contained in plain SQL files (table, view, and trigger definitions).

FADA scripts can contain SQL in addition to FADA commands.

SQL query optimization

EXPLAIN

In the code editor (script or SQL), a query can be selected and tested.

  • F5 : Executes the query: displays the data (SELECT) or shows the result (INSERT, UPDATE, etc.) without actually modifying the data (a ROLLBACK is called after the test query).
  • Ctrl + F5 : Executes the query with EXPLAIN QUERY PLAN prepended: displays a color-coded breakdown based on the theoretical speed of each action.
EXPLAIN QUERY PLAN in FADAcore
  • Ctrl + Shift + F5 : Runs the query with EXPLAIN prepended to it, displaying the results color-coded based on the theoretical speed of each action.
EXPLAIN in FADAcore

Execution times

Executed SQL queries are logged in the current log file, along with their execution time.

Only SELECT statements with an execution time of more than 100 ms are logged.

Menu Edit/Open Log File