Re: Name clashes in lookup by title

Um, they seem to be sorted by node_id, highest (newest) first, just like you wanted.

If I'm wrong, could you point out a conunterexample?

Comment on Re: Name clashes in lookup by title

Replies are listed 'Best First'.
Re(2): Name clashes in lookup by title by bart (Canon) on May 06, 2004 at 10:41 UTC
They appear to be listed sorted by reverse node_id, but I seriously doubt they are searched that way. In SQL terms, I think there's one of `SELECT ... LIMIT 50 SELECT ... ORDER BY node_id LIMIT 50` [download] with perhaps a sort done in Perl, but not `SELECT ... ORDER BY node_id DESC LIMIT 50` [download] which in that case would likely fix it. (I'm not pmdev, so I have no access to the actual source, so I'm just guessing.) For example, a search for List of Lists shows 128632 at the top, and 17802 at the bottom. That's nowhere near the 350865 for the node (list of lists (LOL)) I was actually looking for. As an aside, note that my search term is actually part of the node title, which is not the case for any of the results shown.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re(2): Name clashes in lookup by title
by bart (Canon) on May 06, 2004 at 10:41 UTC

listed

searched

   SELECT ... LIMIT 50

   SELECT ... ORDER BY node_id LIMIT 50
[download]

   SELECT ... ORDER BY node_id DESC LIMIT 50
[download]

For example, a search for List of Lists shows 128632 at the top, and 17802 at the bottom. That's nowhere near the 350865 for the node (list of lists (LOL)) I was actually looking for.

As an aside, note that my search term is actually part of the node title, which is not the case for any of the results shown.