Slow performance Wordpress,MySQL on Windows Server with IIS fastcgi

Hi,

Faced performance problem with an internal WordPress site.

I changed the settings below and my speed improvement went from +1650ms to 450ms.

The default is set to localhost.

/** MySQL hostname */
define('DB_HOST', 'localhost');
Change this to 127.0.0.1

/** MySQL hostname */
define('DB_HOST', '127.0.0.1');

full stack developer

My interesting topic , daily leaning new things.

What is a Full-Stack Developer?

Developer specialized in everything from front-end to back-end; to a developer who has a general knowledge in all steps from concept to finished product.

Full-stack developer to have specialized knowledge in all stages of software development.

Stages,

1.Server, network, and hosting environment
2.Relational and non-relational databases
3.How to interact with APIs and the external world
4.User interface and user experience
5.Quality assurance
6.Security concerns throughout the program
7.Understanding customer and business needs

ssrs, reports session time out

Hi, I've faced ssrs report - Session timeout issue. Searched and fixed the issue.

Go to administrator account (most important) and

i.choose site setting-->general

ii. choose do not timeout (radio button)

iii. click ok

iv. restart SQL server reporting services

mysql grant privileges

mysql> CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'user_name'@'localhost' WITH GRANT OPTION;
mysql> CREATE USER 'user_name'@'%' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'user_name'@'%' WITH GRANT OPTION;