Update issues (3.0.165 -> 3.0.257)

[joaomota]

I recently decided to update the ProcessWire version on my site. I went from version 3.0.165 to 3.0.257 (I hadn't updated it in several years). During the update, I also installed Page Paths (recommended for faster page indexing). This update caused major database issues, such as heavy load, constantly hovering between 90% and 100% and queries taking a very long time (something I thought PagePaths would resolve). We have approximately 2 million pages, each supporting both PT and EN.
For the update, I completely updated the WIRE folder (deleting the old one and adding the updated version), the index.php file, and the composer file.

Any suggestions on how to fix this?

Thanks.

Edited 12 hours ago by joaomota