cd34

An in-depth look at MySQL's Query Optimizer and Index performance over a large variety of tests. Includes the code used to run the benchmarks.

A page describing how to install mysql-python on Snow Leopard

An article in plain English with examples to help you better understand how to use Indexes and optimize your MySQL queries.

A comparison of the development of two applications using both frameworks and a point by point comparison of several key areas.

While talking about Wordpress and it's abysmal performance in high traffic situations to a client, we started looking back at Varnish and other solutions to keep their machine responsive. Since most of the caching solutions generate a page, serve it and cache it, posts and comments tend to lag behind the cache. db-cache does work around this by caching the query objects so that the pages can be generated more quickly and does expire the cache when tables are updated, but, its performance is still lacking. Using APC's opcode cache or memcached just seemed to add complexity to the overall solution.

An IDE/SATA adapter for use in laptop computers and other machines that utilize 2.5 inch disks so that you can use Compact Flash cards.

Kim Sacha is one of the top Zuma players (a popular game on Xbox 360) in the world and she shows us how she does it. Why is this important? Because casual gamers are turning out to be an important market for game designers. Also, women are changing the face of gaming and you get a look at why she got into the game, and get some tips for Zuma playing of your own.