I had a bit of a major problem with Twita (the new name of twitalytics.dataconnect.be, as somebody else has started using twitalytics). Basically I was consuming too much sql and cpu resources on the shared server I was running my cron job on.
The cron job is back up and running, with a reworked sql in it that seems to be loads lighter than what I originally wrote. Apparently using count() to just check if some field and value exist in your table does major lookups to your table, even with indexes set and everything. 
The admin guys have checked their logs and I have checked mine, and it seems we can ‘let the beast go!’ again.
* Let the beast go is a famous phrase from our firstwhile premier Jean-Luc Dehaene while visiting the US and riding on a mechanical steer in a tourist attraction.
