So I moved my attachments from the DB to the filesystem last week after discovering that the DB had ballooned to over 500mb, after which it was a reasonable 22mb.My secondary concern is that I know we send a lot of duplicate attachments. For example, almost all sales related tickets would include the exact same set of PDFs (payment info, W9, tax & liability details, etc). Does OST support any way of detecting duplicate file attachments, or am I left to dedupe at the filesystem level? We're over 3500 tickets deep at this point and I can foresee this problem getting much worse before it gets better.

osTicket attempts to de-duplicate attachments in the database.  I don't think that it does it if you use the filesystem plugin (but I also haven't tested that).  I seem to recall a comment from one of the devs in the last couple weeks that they were working on making de-dupe better in a forth coming version , but I can't find the post right now.

Write a Reply...