Since 2.0.4 was released, it seems to be taking about 5 TIMES LONGER to rebuild the search tables! I'm wondering if other converter authors are experiencing this issue. The only real change I made to the code to rebuild the search tables in 2.0.4 was this:
Code: Select all
if ($phpbb_version < 204)
{
add_search_words($post_id, stripslashes($post_text), stripslashes($post_title));
}
else
{
add_search_words('global', $post_id, stripslashes($post_text), stripslashes($post_title));
}
I am pretty sure I have done this correctly. It looks like 2.0.4 fixed a bug with search_stopwords and added an index to one of the search tables, but neither of these explain why it is resulting in 5X the server load!!! I believe this is a significant server load issue that the phpbb developers need to be aware of, but I would like confirmation from other converter authors.
BTW, I wrote a special javascript version to automatically restart the rebuild process when it times out so that the user doesn't have to keep restarting it. This was necessary because some folks couldn't even get it to do 50 posts before timing out! This was never an issue prior to 2.0.4.
