Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

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

closed
None
1
2004-06-10
2004-06-09
Jamie McCarthy
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