The below is an off-site archive of all tweets posted by @mjtsai ever

January 7th, 2015

@leebennett Looking at the code, it seems to do one database transaction per comment…

via Tweetbot for Mac in reply to leebennett

@leebennett I'm not, but I believe Daniel Chvatik was using Drupal for one of his businesses, so perhaps see who he used.

via Tweetbot for Mac in reply to leebennett

@leebennett DB server has now been moved to the same data center, and WordPress (no plug-in) deleted the remaining 4,000 in a few seconds.

via Tweetbot for Mac in reply to leebennett

@leebennett Turns out that after upgrading my Web server it was in a different data center (and coast) than the MySQL server.

via Tweetbot for Mac in reply to leebennett

@leebennett Yes, but it was really slow. After several hours it had only deleted 8,000 or so spammy comments out of 12,000.

via Tweetbot for Mac in reply to leebennett

@leebennett I am getting thousands per day, and it was no longer auto-emptying after x days. Manually emptying would time out.

via Tweetbot for Mac in reply to leebennett

Yosemite and DYMO label printer issues seem to be solved by direct-connecting, no USB hub. Try that on a 12-inch Air… mjtsai.com/blog/2014/12/0…

via Tweetbot for Mac

The Batch Comment Spam Deletion plug-in for WordPress seems to be working, albeit slowly, to empty spam w/o timeout. wordpress.org/plugins/batch-…

via Tweetbot for Mac