A to the W

Firefox Version: 3.6.3
Chrome Version: 5.0.375.29 beta

Filesort is a performance degradation. I was testing myself with a few queries and converting them to Index sorting. For example:

Did I approach the problem correctly to remove the filesort?

On April 1st I gave up on World of Warcraft, like a colleague of mine said "time has stood still for too long." For me to end my WoW account I decided to remove the credit card information necessary for automatic account renewal. The only way the account could be re-activated was through adding a game time card or your own person-ably identifiable credit card. I had neither the time, energy or will to begin playing quite possibly the most addictive game ever, but apparently someone else wanted to play for me.

So on April 27th I received an email from Blizzard support stating that one of my characters was found abusing the economy on one of the servers and that my battle.net account was banned for seventy two hours. Unfortunately I haven't played the game since April 1st so this was a bit of a misnomer to me. I tried contacting blizzard support via "billing@blizzard.com". From April 27th till This afternoon April 29th I have sent four emails and have only gotten responses from their automated system. In this span of time I have called their support numbers a total of twenty times from work and from my cell phone. Additionally I tried posting on the forums but since my account is not eligible to post on the forums I have no way to contact them. Subsequently that forced me to move my hand and file a formal IC3 complaint with the FBI using Mike Morhaime as the defendant on the docket using his office address. Additionally I filed a complaint with my states attorney general. Here is why.

Thanks to the email being publicly shown in the account they accessed my Gmail account and performed numerous man in the middle attacks for sites that I kept private such as Paypal, Sprint, Sallie Mae (still paying those stupid student loans), Newegg, etc... The list was about twenty companies long, so one bye one I had to visit each website, use a new email address and change my password, or call customer support and verify who I was. The sad part about this is that some of the email change notifications went to the existing email address (which is a stupid thing to do by the way!) which was compromised.

In the end Blizzard has not gotten back to me, I was thinking about buying SC2 via battle.net but after this recent snafu I think I will pass on Blizzard products for a very long time.

I have been learning more about different frameworks out there. Since throwing live http://www.dating2p0.com as a collector for email addresses for our beta program I have been charged with the task of building the full fledged website. Back end/Front end and everything else in between. So far I have been evaluating Kohana and have found both 2.3.x and 3.x exceptional builds. My main concern is the internal struggle between 3.x and 2.x chains. It seems they want to put the clamp on 2.x and go with 3.x full time. My problem with this is the lack of API documentation and the "look at source code" mandate when you ask a question. Another framework I have been looking at is Zend Framework.

Once again a perfectionist looking for clear concise documentation I was disappointed with the way Zend Framework is documented in regards to the References examples. Some reference examples are great and some are left yearning for more. In the quest for more knowledge I have been look around at various user groups and other forms of communication (irc.freenode.net/#phpc) and stumbled upon the awesome Ray Allen. A.k.a akrabat he helped me get started with: http://akrabat.com/zend-framework-tutorial/. A must read for anyone looking to get into Zend Framework.

On top of evaluating various PHP frameworks I have been reading High Performance MySQL (http://oreilly.com/catalog/9780596003067). This book is awesome and also a must read. I have learned so much and am only on chapter four.