Hot Words is DOA
I had to turn off the Hot Words option on the site last week. There are just to many news items in the database now and the script that I had written to parse out the most popular words of the day in 5 different languages was bringing the server to it’s knees. Ok… fess up time. The script was poorly written. Once I get a chunk of time I’ll rewrite it and optimize the php code. I’ll also have to figure out how to work Sphinx into it.
Daily bandwidth is way up. ISP called me today to tell me that I have pay $50 more a month. This is the second time in three months now that host costs have gone up. At this rate I’ll be broke soon. Don’t want to throttle but I might be forced to. 