XF 2.3 Server limits changing (php.ini / my.ini) to prevent load errors or speed up the process / upgrade and import

[Scandal]

Hello all!

I have a question related to importing system (between two xF2.3.7 forums) and also xF2.3 upgrade from xF2.2.
Do you suggest any constant or temporary server php.ini and my.ini limits changes to speed up the process?
For example, on import-finalize (localhost / xampp), the rebuild job rebuilds Posts. This process on my localhost is very slow. It takes hours.

My question is also related to prevent errors due to low php.ini or my.ini limits.
I want to minimize process breaks due to this situation.

 

[Scandal]

Any suggestions?

 

[MySiteGuy]

There is no one size fits all for optimizations due to differences in traffic, ram, CPU(s), storage type (SSD vs NVMe vs traditional hard drive), database version, PHP version, type of web server software, etc.

Proper optimization requires looking at web/php performance stats, MySQL data, tuning, and then following up after a reasonable amount of time to gather new statistical data, and additional fine-tuning. Done wrong, things can go wrong, such as seeming faster until you get hit with a large traffic spike and your "optimizations" use so much memory that the swap file is hit, and the site drags to a near halt.

 

[Scandal]

There is no one size fits all for optimizations due to differences in traffic, ram, CPU(s), storage type (SSD vs NVMe vs traditional hard drive), database version, PHP version, type of web server software, etc.

Proper optimization requires looking at web/php performance stats, MySQL data, tuning, and then following up after a reasonable amount of time to gather new statistical data, and additional fine-tuning. Done wrong, things can go wrong, such as seeming faster until you get hit with a large traffic spike and your "optimizations" use so much memory that the swap file is hit, and the site drags to a near halt.

Basically, I'm talking about temporary php.ini / my.ini changes just for the upgrade and import processes.
Not to leave these settings constantly. Just temporary while the xF2 board is closed for these processes.