hmm, that post
, discussing the new style talk* urls for entries in clustered journals, made me think ..
right now, the url of a entry in a clustered journal gets an url like this:www.livejournal.com/talkread.bml?journal=username&itemid=local_id
while unclustered journals still have the old style urls like that:www.livejournal.com/talkread.bml?itemid=global_id
a) use numerical id of a journal/user instead of the name ?
journal/user names are not unique over time ..
what if a username is deleted and later reused by a new user ?
or some user decides to pay the fee for renaming their account ?
since the numerical ids of users are unique and dont get recycled, i think they should be used instead to avoid the problems mentioned above.
since comparing integers is faster than comparing strings, the db index tree operations might be a bit faster for integer keys than for string keys. so it might be faster to have only numerical ids for the entries. i dunno how much faster that variant would be, but im sure it wouldnt be slower.( Collapse )