HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Slow Spam deleting


We’re running Helpspot with IIS/SQL Server and deleting spams is quite slow. Over weekends we’ll get 100+ spams and it seems like each spam takes several seconds to process causing PHP to timeout. I’ve increased the PHP timeout to 200 seconds its still not long enough.

Is there anyway we can speed up the spam learning/deletion processing ?


Hi John,

SQL Server seems to slow with batch deleting the spam, we believe because of the transactions. We’re looking into speeding it up, but one way to work around it for now is to do some of the deleting outside the HelpSpot interface. The link below has a script for deleting spam which directly deletes spam. It won’t train the system though, so you can use this to delete most of the spam, but you should still occasionally manually delete it so that the system can learn from the spam.

It sounds like your system is well trained so it should be safe to do this as long as you occasionally do it manually so that the system can learn new forms of spam.