Implemented Add index to xf_node to support very large number of nodes

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
ALTER TABLE xf_node ADD INDEX `display_in_list` (`display_in_list`, `lft`);
and it greatly improved performance.