Mike Tougeron
Well-known member
When there are is a large number of nodes (10,000s) but only a subset to be displayed the select query to get the list of nodes for the home page can be slow because it doesn't have an index on the 'display_in_list' field. I added this index
and it greatly improved performance.
Code:
ALTER TABLE xf_node ADD INDEX `display_in_list` (`display_in_list`, `lft`);
Upvote
5