I have a perl script that runs in an account on my WHM cPanel server that's quite heavy on resources.
I've recently got myself a new VPS with more ram, more processors, better network connectivity etc.
Initially the script wouldn't work because of a lack of DBD/mysql.pm which I installed after finding this command in the forums somewhere, which worked for me:
/scripts/perlinstaller --force Bundle::DBD::mysql
It subsequently ran without an issue, but was considerably slower than it was on the much lower spec, older VPS. Ten seconds on the new server, five seconds on the old.
The script does a lot of database access and a lot of writing files to the filesystem (it's a script that pushes out a static website with circa 2000 pages, based on database content).
Everything else on this new server WHM, cPanel, websites etc etc is noticeably faster than it was on the old one.
How can I improve the speed of this perl script? Why might it be slow? I'm running PHP-FPM - related?
Thank you!
I've recently got myself a new VPS with more ram, more processors, better network connectivity etc.
Initially the script wouldn't work because of a lack of DBD/mysql.pm which I installed after finding this command in the forums somewhere, which worked for me:
/scripts/perlinstaller --force Bundle::DBD::mysql
It subsequently ran without an issue, but was considerably slower than it was on the much lower spec, older VPS. Ten seconds on the new server, five seconds on the old.
The script does a lot of database access and a lot of writing files to the filesystem (it's a script that pushes out a static website with circa 2000 pages, based on database content).
Everything else on this new server WHM, cPanel, websites etc etc is noticeably faster than it was on the old one.
How can I improve the speed of this perl script? Why might it be slow? I'm running PHP-FPM - related?
Thank you!