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

closed
None
1
2004-06-10
2004-06-09
No

Rob,

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

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

Discussion

  • Rob Malda

    Rob Malda - 2004-06-09

    Logged In: YES
    user_id=288856

    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
    user_id=3889

    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.