Why not integrating node_last_viewed into node_load()?
Currently seeing smth like this on /user/root/track (devel query dump):
.92 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 109
0.99 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 108
0.93 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 107
1.13 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 106
2.13 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 105
1.15 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 104
0.83 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 103
1.12 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 102
2.43 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 101
1.24 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 99
0.95 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 97
1.26 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 95
0.93 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 94
0.9 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 93
0.93 1 node_last_viewed SELECT timestamp FROM history WHERE uid = '1' AND nid = 75
Too a lot.
Closed: outdated
11.0 🔥
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Wow this was filed against Drupal 4!
@doq, thanks for bringing this up.
The function node_last_viewed was removed in #1120928: Move "history" table into separate History module → in 2012. Any performance issues will need a new issue with steps to reproduce on a currently supported version of Drupal.