Clean URL question

[eluser]Pascal Kriete[/eluser]
I disagree with Colin on this one.

Just make a new field, let's call it permalink, and then query on that the same way you do with ids. You will still have auto-incrementing ids, for foreign keys and such.

The new field should be populated when you create a new post.

That way all your major processing is done when you insert and not when you get.