P_I wrote:I guess another testcase would be rebuilding the search index using phpBB 3.1 and see if the resultant table size changes.
I've now completed this testcase. I compared ACP->Maintenance->Search index before and after, the Total number of indexed words
dropped by about 2%, but the Total number of word to post relations indexed
increased by about 10%.
When I checked the table size in MySQL, the search_wordmatch table has grown even bigger, by another ~20%.
Subsequently I had MySQL OPTIMIZE the table and it reduced it, but it still is still > 25% larger that the table on our live 3.0.12 forum.
Normal people… believe that if it ain’t broke, don’t fix it. Engineers believe that if it ain’t broke, it doesn’t have enough features yet. – Scott Adams