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

[Mike Tougeron]

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.

 

[Kier]

Seems reasonable. I've added it to the upgrade script for the next version.

 

[Mike Tougeron]

Thanks.