1
Карен
no recommendations
no complaints
Closed
Project title: Website and server administrator for permanent work
Type of cooperation: Periodic employment
Section: Administration
Prepayment: without prepayment
Payment methods: Cash, Bank transfer
Acceptance of requests: closed
Type of cooperation: Periodic employment
Section: Administration
Prepayment: without prepayment
Payment methods: Cash, Bank transfer
Acceptance of requests: closed
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!
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!
