Tuesday, October 21, 2003

Categories added I finally added categories to my 'blog. My entries have actually been categorized for a while, but there were no links to them on the page. Now there's a "Code" category for programming-related stuff and a "Fun" category for the, well, fun stuff. And there will still be the homepage feed, which will contain all entries including those that don't fit into the other two categories (like this one). Feel free to subscribe to the "Code" or "Fun" feeds if this feed is too noisy for you. You won't hurt my feelings. :) 5:10:02 PM    comment []

Dipping into Axion I did some Axion debugging this week. Rod and I discovered that only SQL inserts are utilizing indices. Deletes and updates are performing table scans every time. Today I checked in a fix for simple delete statements, which produced a significant boost. A series of SQL deletes which took 638 seconds to execute before now takes less than 4 seconds. We're working on more complete index support for updates and deletes, so if you use Axion you may want to keep an eye on the repository activity for a while. 5:03:41 PM    comment []