Fixed Query triggering full table scans in a loop when rebuilding master data

[Xon]

Affected version

2.0.10

The tables xf_phrase_map and xf_template_map are repeatedly hit with delete statements using a where on the title which do not match any index.

alter table xf_phrase_map add index title (title);
alter table xf_template_map add index title (title);

 

[XF Bug Bot]

Thank you for reporting this issue. The issue is now resolved.

Change log:

Add title (or type+title) indexes to the phrase/template maps to improve map rebuild efficiency (primarily when inserting a record)

Any changes made as a result of this issue being resolved may not be rolled out here until later.