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.

Comments

Egon Bianchet’s picture

Egon Bianchet CreditAttribution: Egon Bianchet commented
Version: 4.7.0-rc2 » x.y.z
Category: task » bug

This would imply an API change, so I'm moving it to cvs

magico’s picture

magico CreditAttribution: magico commented
Category: bug » feature

This would be a HUGE performance optimization!!!

lilou’s picture

lilou CreditAttribution: lilou commented
Version: x.y.z » 7.x-dev
Category: feature » task
Jody Lynn’s picture

Jody Lynn
she/her
Primary language English
CreditAttribution: Jody Lynn commented
Version: 7.x-dev » 8.x-dev

I don't see how adding this into node_load would improve performance.

Adding a node_last_viewed_multiple function could help though.

xjm’s picture

xjm
she/her
Primary language English
CreditAttribution: xjm commented
Component: node.module » node system
Issue summary: View changes

(Merging "node system" and "node.module" components for 8.x; disregard.)

Version: 8.0.x-dev » 8.1.x-dev

Drupal 8.0.6 was released on April 6 and is the final bugfix release for the Drupal 8.0.x series. Drupal 8.0.x will not receive any further development aside from security fixes. Drupal 8.1.0-rc1 is now available and sites should prepare to update to 8.1.0.

Bug reports should be targeted against the 8.1.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.2.x-dev branch. For more information see the Drupal 8 minor version schedule and the Allowed changes during the Drupal 8 release cycle.

Version: 8.1.x-dev » 8.2.x-dev

Drupal 8.1.9 was released on September 7 and is the final bugfix release for the Drupal 8.1.x series. Drupal 8.1.x will not receive any further development aside from security fixes. Drupal 8.2.0-rc1 is now available and sites should prepare to upgrade to 8.2.0.

Bug reports should be targeted against the 8.2.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.3.x-dev branch. For more information see the Drupal 8 minor version schedule and the Allowed changes during the Drupal 8 release cycle.

Version: 8.2.x-dev » 8.3.x-dev

Drupal 8.2.6 was released on February 1, 2017 and is the final full bugfix release for the Drupal 8.2.x series. Drupal 8.2.x will not receive any further development aside from critical and security fixes. Sites should prepare to update to 8.3.0 on April 5, 2017. (Drupal 8.3.0-alpha1 is available for testing.)

Bug reports should be targeted against the 8.3.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.4.x-dev branch. For more information see the Drupal 8 minor version schedule and the Allowed changes during the Drupal 8 release cycle.

Version: 8.3.x-dev » 8.4.x-dev

Drupal 8.3.6 was released on August 2, 2017 and is the final full bugfix release for the Drupal 8.3.x series. Drupal 8.3.x will not receive any further development aside from critical and security fixes. Sites should prepare to update to 8.4.0 on October 4, 2017. (Drupal 8.4.0-alpha1 is available for testing.)

Bug reports should be targeted against the 8.4.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.5.x-dev branch. For more information see the Drupal 8 minor version schedule and the Allowed changes during the Drupal 8 release cycle.

Version: 8.4.x-dev » 8.5.x-dev

Drupal 8.4.4 was released on January 3, 2018 and is the final full bugfix release for the Drupal 8.4.x series. Drupal 8.4.x will not receive any further development aside from critical and security fixes. Sites should prepare to update to 8.5.0 on March 7, 2018. (Drupal 8.5.0-alpha1 is available for testing.)

Bug reports should be targeted against the 8.5.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.6.x-dev branch. For more information see the Drupal 8 minor version schedule and the Allowed changes during the Drupal 8 release cycle.

Version: 8.5.x-dev » 8.6.x-dev

Drupal 8.5.6 was released on August 1, 2018 and is the final bugfix release for the Drupal 8.5.x series. Drupal 8.5.x will not receive any further development aside from security fixes. Sites should prepare to update to 8.6.0 on September 5, 2018. (Drupal 8.6.0-rc1 is available for testing.)

Bug reports should be targeted against the 8.6.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.7.x-dev branch. For more information see the Drupal 8 minor version schedule and the Allowed changes during the Drupal 8 release cycle.

Version: 8.6.x-dev » 8.8.x-dev

Drupal 8.6.x will not receive any further development aside from security fixes. Bug reports should be targeted against the 8.8.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.9.x-dev branch. For more information see the Drupal 8 and 9 minor version schedule and the Allowed changes during the Drupal 8 and 9 release cycles.

Version: 8.8.x-dev » 8.9.x-dev

Drupal 8.8.7 was released on June 3, 2020 and is the final full bugfix release for the Drupal 8.8.x series. Drupal 8.8.x will not receive any further development aside from security fixes. Sites should prepare to update to Drupal 8.9.0 or Drupal 9.0.0 for ongoing support.

Bug reports should be targeted against the 8.9.x-dev branch from now on, and new development or disruptive changes should be targeted against the 9.1.x-dev branch. For more information see the Drupal 8 and 9 minor version schedule and the Allowed changes during the Drupal 8 and 9 release cycles.

Version: 8.9.x-dev » 9.2.x-dev

Drupal 8 is end-of-life as of November 17, 2021. There will not be further changes made to Drupal 8. Bugfixes are now made to the 9.3.x and higher branches only. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

Version: 9.2.x-dev » 9.3.x-dev

Version: 9.3.x-dev » 9.4.x-dev

Drupal 9.3.15 was released on June 1st, 2022 and is the final full bugfix release for the Drupal 9.3.x series. Drupal 9.3.x will not receive any further development aside from security fixes. Drupal 9 bug reports should be targeted for the 9.4.x-dev branch from now on, and new development or disruptive changes should be targeted for the 9.5.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

Version: 9.4.x-dev » 9.5.x-dev

Drupal 9.4.9 was released on December 7, 2022 and is the final full bugfix release for the Drupal 9.4.x series. Drupal 9.4.x will not receive any further development aside from security fixes. Drupal 9 bug reports should be targeted for the 9.5.x-dev branch from now on, and new development or disruptive changes should be targeted for the 10.1.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

quietone’s picture

quietone CreditAttribution: quietone at PreviousNext commented
Version: 9.5.x-dev » 11.x-dev
Status: Active » Closed (outdated)

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.