Questions tagged [Server optimization] (174)

2
answers

How to reduce the load on the SQL server?

Hello. Tell me how to change the sql server in my situation. Is there a website on WordPress. There is a Python script which parses the content and adds the data in one of the tables of the website. Select queries, update, insert, delete. The problem is that when Python script is running, the website is slow. The queries...
Nathan30 asked April 9th 20 at 10:46
6
answers

How to find the cause of the performance degradation of the applications (apache, php, mysql)?

Your local network has a website where officers do paperwork. Employees enter data, plus background scripts to put their data - only an average of 70 queries to the database per second. It works on PHP 7.2, MySQL 5.7, Apache 2.4 on Windows Server 2012 r2. The application written in native PHP in 2015, gradually complicating...
veronica asked April 8th 20 at 18:37
1
answer

How to optimize memory usage when working with class instances in Python?

I'm writing a game in which there are units. There is a Unit class, which is a repository of information about each individual unit. The class Unit now this structure:class Unit: def __init__(self, color, health): self.color = color self.health = health When you create a unit every time I create an instance of the Unit c...
shaylee.Hintz asked April 4th 20 at 12:45
3
answers

How to optimize download speed with large weight html?

Good day, There is a need to build on the site menu with a large number of directories (about 2000, this for SEO), got about 20000 nodes, html menu takes 400 KB. Please tell me how this is a problem when forming a page the browser (how much effect on speed) - it is such a large amount of HTML and how to optimize (compressio...
2
answers

Nginx + Puma Rails. Why is slow? How to check what's going on?

Hi all. There was a question between selling the nginx server and the application server puma. The application is written in Ruby on Rails. Puma displays a page of 30 MS, sends it to nginx. Nginx gives it to the browser for 300 MS. He makes more than 260 MS. How to understand what's the problem? How to optimize? The web...
Wilber_Collins asked April 3rd 20 at 17:48
1
answer

Why can't I optimize mysql?

All kind time of day! Guys, something does not work to optimize mysql. Yesterday even tech support was contacted, they were stuck for several hours and it is useless, even more slowly the site began to work. Now my configs.cnf theirs and know what you need for example to increase the "max_connections up to 70", just left it...
sterling.Murray99 asked April 3rd 20 at 16:38
2
answers

Why the server is under a low load is slow to respond and the ping increases to 80ms?

Good afternoon, prompt who can faced. Is the server cache to another server video. The video began to ship the wheels so put next to another server made a separate interface at 1Gbit and using the Nginx proxy_cache Directive gives files to the client. So at the moment not even the highest load the ping is increasing from u...
Delpha asked April 2nd 20 at 16:54
3
answers

How to speed up the work with the API?

Is there a website on which people can run tests. The test is a large number of questions that the user answers Yes or no, after clicking on the reply button, the server sends the data via the API to write to database and redirects the user to a new page with a new question (each question is a separate page with the form). ...
lee.Glover asked April 2nd 20 at 16:34
1
answer

Why long the server's response in the analysis through Webmaster?

Without much foreplay let's get right to the point. There is a blog on the CMS Wordpress —khatsker.site Its speed is amazing. Main robot Yandex shows that the server response time 50 MS, and the website on the phone to boot pretty fast(I have are plugins for caching and lazy load). Even PageSpeed Insights who constantly swe...
2
answers

What is the cause of long server response?

The website(on wp) is pretty well optimized, with the PC loaded for 1.5-2 seconds(the whole), but 3-5 in a row request, the page can be loaded 5-7 seconds(just missing the server's response for a long time). Compression is enabled(9). 7.1.2.8 Php (FastCGI (Nginx + PHP-FPM)). SSL enabled. HSTS also, caching is enabled.Virtua...
chauncey_Emard asked March 31st 20 at 21:52