All Posts

Sometimes MySQL needs to work hard. I've been working on an import script that fires a lot of INSERTs. Normally our database server handles 1,000 inserts / sec. That wasn't enough. So I went looking for methods to improve the speed of MySQL inserts and was finally able to increase this number to 28,000 inserts per second. Checkout my late night benchmarking adventures.

Code spends more time being [read than being written](https://www.codinghorror.com/blog/archives/000684.html). I think naturally this is true for queries as well. So it might help if we teach ourselves some guidelines as how to nicely format them. I've searched but at the time of writing, could not find a public Style Guide for SQL formatting. I'll try to keep this guide short and pragmatic, so that it has a chance of actually being read & stuck to : )

If you've written a PEAR package, it's probably a good idea to submit some end user documentation. Here's how to do it.

Hello everyone. Two days ago Feedburner offered me to merge my account with Google. I thought: why not. But apparently now the URL of my feeds changed. This messed up my stats, and your RSS reader has marked all of my posts as unread. I'm very sorry for the inconvenience.

So I've been learning CakePHP the last few days. Bit by bit I've been trying to port a legacy administration app to Cake. 'Secretly' linking menuitems to finished Cake parts as we go. And I must say: I'm pretty excited. I did run into a disturbing conclusion though. I estimated the legacy app will have over 300 Models & Controllers once finished. That could easily add up to (300 x 4 =) 1200 views. And here I am, creating a maintenance hell while trying to solve one!