Jump to content

Community

Adriano Faria

Number of rows converted to UTF-8 in Converter

Recommended Posts

Posted (edited)

I'm upgrading a big board from 3.4.9 to 4.4.2 and I got on large tables, like POSTS:

XBReBiX.png

It's running for almost one hour and I have no way to know if it stopped or if it's running because the 0 (zero) always remains there and the % doesn't change either. It should update the number of rows already converted and/or the %.

Tks.

---------------------------------------

FTvZhgK.png

Edited by Adriano Faria

Share this post


Link to post
Share on other sites

It depends on the method in use.

  1. If PHP is performing the conversion, then we can track what row it's working on in the table and update the converter accordingly. This method, however, is a lot slower.
  2. If MySQL is performing the conversion, then we can't track what row it's working on (because it's done in a single query), however this method is a lot faster than using PHP.

So it's a double edged sword, really. If PHP were to perform the conversion, those 7 hours would have likely been a lot longer.

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...