• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

Mike Tougeron

Well-known member
#1
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
Code:
ALTER TABLE xf_node ADD INDEX `display_in_list` (`display_in_list`, `lft`);
and it greatly improved performance.