Creating Email Messages with Clickable Links that Add Events to Your Calendar

This was an effort to find the best ways to create email messages that contain event information, so that the user can easily create a calendar item.

The stock advice is to use .ics files, yet I don’t see many event publishers using .ics files. Instead, I saw people using well-formatted text, which gets automatically linked by email clients. I’ll look at both methods.
Continue reading Creating Email Messages with Clickable Links that Add Events to Your Calendar

Help Speed Up a MySQL Query by Helping the Optimizer

Here’s a noob-to-noob optimization trick. Suppose you have a database table with, say, 200,000 records, and you regularly select on multiple criteria. The rule for selection is to put the most specific WHERE clause first, and the least specific last. The goal is to cut down the search set to something small, and then search through the smaller set. Get all the queries using this order, then create a composite index over the keys to speed up the search even more. Continue reading Help Speed Up a MySQL Query by Helping the Optimizer