Optimising Storage: Managing Ticket Attachments Efficiently

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
adildev89
Posts: 7
Joined: Wed Apr 17, 2024 10:47 am

Optimising Storage: Managing Ticket Attachments Efficiently

Post by adildev89 »

Hi



At my company, the technical team handles large open tickets with extensive customer attachments, often big image files. Once resolved, I suspect these files aren't automatically deleted, leading to significant unnecessary storage usage in GBs. How can I optimise this process?



Kind regards


Adil
Klemen
Site Admin
Posts: 10139
Joined: Fri Feb 11, 2005 4:04 pm

Re: Optimising Storage: Managing Ticket Attachments Efficiently

Post by Klemen »

No data is deleted when a ticket is marked resolved.

You can either delete old tickets or delete files manually from the "attachments" folder.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
shadedk
Posts: 35
Joined: Fri Aug 07, 2020 1:17 pm

Re: Optimising Storage: Managing Ticket Attachments Efficiently

Post by shadedk »

Hello adildev89,

Maybe you can use what I do. I run HESK on a Linux server with jpegoptim, pngcrush, and optipng installed. I use this little script to optimize the size of image files, as they are often the ones that take up the most space:

Code: Select all

#!/bin/sh

for i in find . -name "*.png"; do pngcrush -e .png2 -rem allb -brute -reduce $i mv ${i}2 $i optipng -o7 $i done

jpegoptim --max=85 --strip-all --preserve --totals *.jpg 
After the last run (it had been a while), our attachments folder went from 169MB to 82MB. So, it is quite an improvement.
Klemen
Site Admin
Posts: 10139
Joined: Fri Feb 11, 2005 4:04 pm

Re: Optimising Storage: Managing Ticket Attachments Efficiently

Post by Klemen »

Thanks for sharing the image optimization path, that's also an option (not for all users, of course).
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Post Reply