pf » Tag: optimization on Pete Freitag's Blog

Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.

That's a quote from Dare Obasanjo at Microsoft who worked on the MSN Spaces project.

I just discovered that MySQL has some handy optimization hints, and commands that you can pass in your SQL statements. Since there is a lot to cover with each tip, I will be posting them in separate blog entries. I have already written about the MySQL Query Cache optimization hints.

Google recently held a webinar for AdSense publishers. They gave out some adsense optimization tips that they have gathered over the past few years. The transcript is pretty lengthy, so here's the summary:

Ad Location - "the middle, above the fold location perform best.