PCS Andy

Fixed!

I spent some time looking at the mysql config (memory, threads etc.) which didn’t really help.

Forcing IIS to cache all pages made things V speedy (but broke the site)

In the end i found this reference:

https://rietveld-ict.nl/slow-performance-mysql-on-windows-2012-with-iis-8/

Which pointed me towards editing the wp-config.php file from:

/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);
to

/** MySQL hostname */
define(‘DB_HOST’, ‘127.0.0.1’);
response times have dropped from ~1600ms to ~500ms

i found an article which recommends using shared memory for mysql connecitons:

https://mysqlserverteam.com/improving-the-performance-of-mysql-on-windows/

Any tips on getting wordpress/mysql to switch to shared_memory connections instead of tcp/ip?

Thanks

Andy