I'm using FME Desktop 2020 and have a workbench with several SQLExecutor transformers. These are performing 1000s of SQL queries against a PostGIS database and working fine. The only issue I have is that every SQL statement is being logged in the FME log, which is creating a bloated log file (100s of MBs in size).
I don't need to see the individual SQL statements in the FME log, but these are coming through as INFO level messages (I would actually class this type of logging as DEBUG not INFO level log messages).
I know there are options to turn off INFO messages, but other INFO messages may be useful.
So it would be beneficial to either:
- Treat logging of SQL statements as DEBUG level messages so that they do not get logged with the default INFO level set.
- Have an option to turn off logging of SQL statements globally.
- Have an option to turn off logging of SQL statements on the individual transformers (e.g. SQLExecutor, SQLCreator).
This would prevent bloated log files when hundreds/thousands of SQL statements are executed during a workbench run.
