We are storing PDF documents in x12 container fields and have noticed that the database has started to bloat in size. We are using SeedCode's "Go Zync" to keep mobile devices synced to the remotely hosted file so we are unable to use External Storage unfortunately.
Is there an easy way to export each PDF, reduce it in size then re-import it back again? The script would need to check each of the 12 container fields for every record.
Our PDF scanner is set to scan at 300dpi so I think I will reduce to maybe 100dpi to prevent this happening again...