Issue of hosting load

Started by soxcell, Nov 19, 2022, 02:39 AM

Previous topic - Next topic

soxcellTopic starter

Hello for everyone. Maybe I'm not writing there, but I'll try anyway. I am a content manager. I am engaged in filling sites. I am filling out 1 site (the site is in the filling stage). I fill it out 1, no one else fills it out.
The hosting providers write to the customer that there is a big load on hosting. I attach a letter from the hosting provider.

You are a SpaceWeb customer.
Your login: ***
Contract number: ***
Over the past day, the load created by the MySQL databases of your account amounted to 2764 processor seconds. This exceeds the permissible load of 1000 processor seconds on virtual hosting tariffs and is a violation of clause 2.11 of the Rules for the Provision of Services specified in Appendix 1 to the Public Offer Agreement.

In accordance with clause 2.3. of the Agreement, the work of the account may be suspended: "2.3. The Contractor has the right to suspend the provision of services in cases of violation by the Customer of clauses 2.10-2.12. of Appendix 1 to this Agreement until the reason for the suspension of the provision of services is eliminated."
In order to avoid the shutdown of your account, please reduce the load created as soon as possible.
To reduce the load, we recommend:
to carry out technical work on optimizing SQL queries in site scripts.
use indexes in databases

The customer writes to me that I am putting a load on hosting, adding a lot of goods per day (on average 150-200 pcs. per day).
This is a description of the creature and a picture of 100-200 kb. And I, alas, do not understand the load on hosting.

Please give me some advice!!!
Is the customer right that I put a load on hosting with my filling, or is it not about me. Then tell me how it can be fixed.


the site was made by newbie, whose hands are worth tearing off for such performance.

Host swear at the CPU load of the DBMS, this is just because of the large number of calls to the database during filling. And what will happen with a bunch of complex read requests, I'm even afraid to imagine.
How to solve: to convey to the customer the idea that saving $1 per month, he loses on the performance of the site on such hosting by overdoing conversions.
The download speed of the same product catalog directly depends on the response time of the database, so it is in his interest to change web hosting to something adequate.


What to do if page rendering slows down:

Configure deferred JavaScript loading. Let the largest JS files be loaded at the very end and not slow down the display of the rest of the content. To set up a delayed upload, configure calling an external JS file before the </body> tag.
Use asynchronous script loading. When loading synchronously, the page is often displayed in the browser with delays, since the browser will not display the page until it processes CSS and JS files. Asynchronous loading gives the browser the ability to load an HTML page, even if it has not yet processed the js and css files.
Place links to CSS files before links to JavaScript files. So the page will load gradually: title, logo, headings, top blocks, etc. If you place CSS files after links to script files, the browser will slow down and try to load all the elements at the same time - after a few seconds of waiting.
Remove all unused code elements: empty lines and line breaks, unnecessary comments, extra spaces, tab characters. This will reduce the file size and the browser will load it faster.
It is better to store two versions of files: a development version (where all comments and convenient formatting are saved) and a minified version for posting on website.