#16 Link to article.pl: old sid, or new stoid?



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
Mysterious Future?

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...


  • Rob Malda

    Rob Malda - 2004-06-09

    Logged In: YES

    Sorry- we need old fashioned sids. sequential article IDs would be a
    pain... just like sequential UIDs are now.

  • Jamie McCarthy

    Jamie McCarthy - 2004-06-10

    Logged In: YES

    Oh well. OK.

  • Jamie McCarthy

    Jamie McCarthy - 2004-06-10
    • priority: 5 --> 1
    • assigned_to: cmdrtaco --> jamiemccarthy
    • status: open --> closed

Log in to post a comment.