Steps:

1. Notice that site has become really slow the last few days.
2. Stumble upon a fantastic resource by Ian Gilfillan for people with limited MySQL experience.
3. Slap forehead and finally turn on slow query logging to find queries that take more than one second.
4. Realize that, oh crap, we’re reading every row in the session id table constantly.
5. Add an index to the session id table to fix that.
6. Try to fix other expensive queries that use sorting.
7. Fix those by upping the startup variables that effect sorting cache.
8. Forgive self for rookie mistakes because I’m a CSS jockey not a DBA.

As the quasi-PR person for Newshutch, I keep track of what people are saying about us. I do this by looking at referrer traffic, blog/forum comments, and with Feedgit.

One interesting post I recently saw on Feedgit was posted July 6, 2006 on a Spanish language blog. Mario Núñez, the author, posted what looks like a Spanish guide to using Newshutch. Poorly translated by me, the post title is almost Vader-esque: “An excellent way to begin to know the power of RSS“.

Someday we’d like to translate Newshutch into other languages, but until we have the time and budget, keeping things simple is a fair substitute. Before we launched, I was dreading writing the site copy. The way around the pain was to write as little as I could get away with, while still communicating what Newshutch is and why you’ll like using it. The combination of words and pictures turned out pretty well I think.

An added bonus is that it’s somewhat easier for non-English speakers to use Newshutch. When we do actual translations someday, we’ll have fewer words and interface elements to deal with. I love it when writer’s block pays off.

Doug and I were interviewed by Josh Owens and Chris Saylor of the Web 2.0 Show. They typically have high caliber guests, so it was a real thrill to be on their show.

A little “behind the scenes” trivia: In the original interview there was something of an awkward pause at about 17:05 after I go on an anti social software feature creep mini-rant, but Josh and Chris thankfully edited the awkward pause out. What I really meant to say was that instead of making tagging, tag clouds, friend groups, and all that stuff central to the Newshutch experience, we want to use the principles of social software in subtle ways. For example we could use categories as “tags” and “flagged” entries in interesting ways without explicitly making Newshutch a “social software” application.

Other highlights include Doug getting into the nitty gritty technical side of Newshutch, and me waxing ecstatic about how great it is to not have a boss. Many thanks to Josh and Chris. They were a lot of fun to talk to and excellent hosts.

Enjoy!

Web 2.0 Show Newshutch podcast and show notes.

No user interface design mistake bothers me more than when too much information is forced into a tiny non-resizable area. As usual, Microsoft is the worst offender.

Microsoft Money won’t let you see enough categories:

Internet Explorer’s settings pane forces you to scroll right:

Add hardware wizard makes you scroll a huge vendor list in a tiny space:

This is so frustrating because it smacks of lazy programming. Is it really that hard to make all windows resizable? Any time you force users to remember things instead of showing them what they are looking for it’s a UI failure.

Version 1 of Newshutch had this problem because too many important interface options were at the bottom of a huge feed list. If you checked feeds to delete, you would forget what you had checked by the time you reached the “delete” button. Since then we’ve added scrollable panes and we use fixed positioning (which doesn’t work in IE) for the “manage” options. I’m not saying Newshutch is perfect, but we aren’t worth billions and our add hardware wizard hasn’t sucked since 1995.

If you want to see some real doozies, check out the Interface hall of shame.

Some of you IE users may have noticed that when you try to use the browser bookmarklet button “Add to Newshutch” directly on an XML (or RSS, or Atom, etc…) feed, the bookmarklet fails.

For some reason, IE doesn’t like javascript bookmarklets when the page in the view port is XML. It just fails silently. I tried using the bookmarklet on images and even local files and IE would at least make the submission to Newshutch.

Perhaps we’ll be able to fix this by using a referrer or something, but I’d much rather browbeat every Windows user into switching to Firefox.

Fortunately this problem only effects 10% of Newshutch users:

Sheesh, I can’t believe I spent all that time figuring out why Opera wouldn’t render feeds at full opacity