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;

Site traffic source and medium

Hi,

Today learn google analytic, traffic source and medium.

Source / Medium. 

Source: the origin of your traffic, such as a search engine (like, google,bing,yahoo) or a domain (irctc.co.in). 

Medium: the general category of the source, (for example, organic search (organic), cost-per-click paid search (cpc), web referral (referral), email campaign). 

Solved Mix match content issue

Hi,

Daily I've received new experience, today fixed mix and match content in blog.

Searched and found WordPress plugin.

Installed activities Really secure SSL plugin and resolved the issue.

Note. If anyone using cloudflare SSL certificate and use cloudflare plugin.

Have a good day!

Rewrite rule in iis

N numbers of  4xx series and 5xx series rewrite rul map in iis and web.config.