Hi Guys,
I have been doing some database maintenance as our database is now over 20gig, which seems very large......and is getting quite slow.
I have noticed the SY_File Table is 15gig out of the 20gig, on further investigation it would appear that every time we email a customer an invoice directly from Jiwa a binary copy of the PDF is being saved to SY_File.FileBinary.
Is there any reason/point of this?, and can I clear this table?
I have made a copy of my DB and tested and it doesn't appear to affect jiwa in any way, however I'm not willing to do the same thing to my live DB without some sort of conformation.
Cheers
Robin