firebird icon indicating copy to clipboard operation
firebird copied to clipboard

[FR]: Suppress write blobs mon$sql_text and mon$explained_plan in virtual table mon$statements for Firebird 5

Open basid-irk opened this issue 9 months ago • 1 comments

Firebird 5 add new (virtual) table mon$compiled_statements with blobs mon$sql_text and mon$explained_plan. In (virtual) table mon$statements added field mon$compiled_statement_id. Now fields mon$sql_text and mon$explained_plan in mon$statements are redudant. Suggest add parameter (server and database level) for suppress fill blobs in fields mon$sql_text and mon$explained_plan of table mon$statements.

basid-irk avatar Mar 25 '25 15:03 basid-irk

Better optimize the MON$ blob storage to make it a non-issue from the performance/overhead POV.

dyemanov avatar Mar 25 '25 16:03 dyemanov