This Genero tool can read an FGLSQLDEBUG output, to show the log records in a graphical interface. You can then sort, search and filter log records, to find SQL statements to be optimized or fixed.
- Latest Genero version
- GNU Make
- make clean all
- Load the fglsqldebug.4pw project
- Build the project
- Get an FGLSQLDEBUG log to analyze
- Define FGLSOURCEPATH to the .4gl sources that generated the FGLSQLDEBUG log
- Run the tool with fglrun fglsqldebug [-f logfile [-r]]
- In the first field, you can load another log file
- Use the Filter panel on bottom of the form to filter log records
- Run profiling statistics for find time consuming SQL statements
The log records are loaded into an SQLite database created automatically if it does not exist. One database file is created for each log. By default, the tool does not re-parse the log file if the database exists already. You can force a re-parsing with the -r option.
The tool can also show the source file, if the FGLSOURCEPATH environment variables is defined.
See Genero BDL documentation for more details about FGLSQLDEBUG and FGLSOURCEPATH environment variables.
- 1.01: Multiple directories in FGLSOURCEPATH
- 1.02: Bug fixes
- 1.03: Global statistics
- 1.04: Avoid freezing program (with IFX) when trying SELECT to check DB availability