PHP / MySQL Massively different speed differences between servers

[Jeremy James]

Hi there

Really stuck on this one

I've got five different windows servers all running PHP 5.6.40, on mysql 5.6

all with the same settings in php.ini
all with the same OI
all with the same RAM
all with the same mysql configs
all on IIS for web server

two servers massively fast
one massively slow
the other two relatively slow

when running the exact same PHP script / mysql database query

how can that be possible?

how can there be such massive differences in php / mysql performance?

what possible setting am I missing?

literally 1 minute loading a report that on another server is loaded within 4 seconds

another server loads it in about 15 seconds
another 40 seconds
another within 5 seconds

all the same PHP / Mysql setups as far as I can tell (copy paste php.ini, same versions and same mysql configs)

what could be making such radically different performance issues here?