Jump to content

Number of rows converted to UTF-8 in Converter


Adriano Faria

Recommended Posts

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

Link to comment
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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...