Using Ignition 7.9.2, a gateway backup has 118 MB, of which the database backup (.idb) has 114MB.
The project_resources table in this database takes 97% of this space.
Looking at the largest rows in this table by blob size, they are mostly old/deleted windows, which no longer appear in the designer.
An export from the designer for all windows takes 11MB.
We took a look at this database because the internal db backups were taking longer and longer, blocking the gateway.
My question is, how do we compact/clean the project_resources table and if it is advisable.