Project description
Hey, everybody!
We are looking for a talented administrator with programming skills in PHP, JavaScript and of course with knowledge of the SQL language, knowledge of Apache, Nginx, MySQL, SSH, Linux and so on and so on.
We are not looking for 100% pros, but you need to be able to solve any problems that arise quickly.
The first task is to optimize SQL queries on the site to get the desired 0.2 seconds. Google's optimizer. At the moment, the page is generated in 1.5-2.5 seconds., which is very long, of which almost all the time takes the execution of requests to MySQL. To achieve the desired result can be achieved both by optimizing the queries themselves and the database structure, and by optimizing MySQL settings.
Now in the shortest possible time you need to achieve optimal loading of the main page. In the future, you need to analyze ALL pages of the site and optimize them yourself.
There are also a number of other improvements and configuration on the server, but more about them later.
It is desirable that the person was from Ufa. We can provide a workplace if necessary, but remote employees are also considered.
Good luck, everyone!
We are looking for a talented administrator with programming skills in PHP, JavaScript and of course with knowledge of the SQL language, knowledge of Apache, Nginx, MySQL, SSH, Linux and so on and so on.
We are not looking for 100% pros, but you need to be able to solve any problems that arise quickly.
The first task is to optimize SQL queries on the site to get the desired 0.2 seconds. Google's optimizer. At the moment, the page is generated in 1.5-2.5 seconds., which is very long, of which almost all the time takes the execution of requests to MySQL. To achieve the desired result can be achieved both by optimizing the queries themselves and the database structure, and by optimizing MySQL settings.
Now in the shortest possible time you need to achieve optimal loading of the main page. In the future, you need to analyze ALL pages of the site and optimize them yourself.
There are also a number of other improvements and configuration on the server, but more about them later.
It is desirable that the person was from Ufa. We can provide a workplace if necessary, but remote employees are also considered.
Good luck, everyone!
Administration Cash, Bank transfer
