The BlogShares Blog

Today SubWolf figured one of the major wedge producers in the php code are a set of SQL queries using some nasty joins. It seems that we need to rewrite all these queries. I think we can get the most efficiency from sub-queries so we avoid the issues of joins entirely. The joins are on some massive tables and always result in writing a tmp table to disk so its very problematic.

So now we are looking at upgrading to MySQL 4.1.1 so we can also take full advantage of table caching. We're not sure if its going to be an easy deploy because of libraries, we're using Debian stable which is unpleasant when you're trying to use modern software.

Posted by at 11:55 PM | Site Development | Permalink

We've fixed share and mailbox bugs and we're now focusing on SQL efficiency. A documentation wiki is in the works.

Posted by jay at 09:50 PM | FrontPage | Permalink

Forums are back. None of the old lost content, unfortunately, but a place to discuss the game and make player deals.

Posted by jay at 09:48 PM | FrontPage | Permalink

We installed a new SQL server (4 GB RAM) on the backside of Blogshares this evening. The site will probably never be zippy but it's certainly more usable. Let me know if you see any problems.

Update: It's going to take more resources than this, even. We're adding hardware, tuning the environment and tweaking the php and java to speed things up. We appreciate your patience.

Posted by jay at 05:33 AM | FrontPage | Permalink