Whole table is rebuilt on node save

joachim - June 9, 2009 - 13:36
Project:Similar Nodes
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

similarnodes_build_cache() wipes out the whole of the similarnodes table and rebuilds it from scratch on every cron run and node save. This is quite probably a performance hit on large sites.
There's a setting for whether to rebuild on node save, but then that still leaves a cron run that rebuilds the whole table.

Wouldn't it be more efficient to drop only the saved node's rows on node save?
With cron though IIRC there's an issue around modules like community tags that change node terms without saving the node -- not sure how that would be best handled.

 
 

Drupal is a registered trademark of Dries Buytaert.