The stories table gets a numeric primary key now, 'stoid'.
Internally that's what's passed around by the code.
For the web interface, it would be fastest for our code if we put
stoids directly into URLs. That would save at least 1 query with
every click, since we wouldn't have to do the lookup to convert
text sid into numeric stoid.
But I believe you made the story primary key nonsequential for a
reason, namely so annoying users who saw that the latest posted
story was 12345 couldn't hit reload on 12346 until the story
Is that still something that we care about, especially now with the
If so, then I'll make sure we continue linking to sid=1/2/3/4 and
that article.pl?stoid= will not work.
But if it is ok, then I'm going to start linking to article.pl?
stoid=12345 wherever possible, since it would be faster.
Let me know...
Log in to post a comment.