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
Here’s a CRC32 function based on the work at: cCRC32.
The main difference is that this is a function, and the crc32 table is not recalculated each time. If there’s a way to do constant arrays, I’d like to know. I haven’t found anything online.
Continue reading MS Access: VBA CRC32 Function
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
I describe how others page over results, and how I do it.
I find fascinating URIs that looks like this:
http://mysite.com/index.php?page=3&search=foo Continue reading Paginating Database Results