The homepage loading speed is slow. Is there a way to optimize it? There are 15 SQL statements on the home page involving 7 data tables. the loading speed is extremely slow (about 6 seconds, 2 MB bandwidth). Is there any way to optimize it? Share To: More homepage loading speeds are slow. Is there a way to optimize it?
There are 15 SQL statements on the home page involving 7 data tables. the loading speed is extremely slow (about 6 seconds, 2 MB bandwidth). Is there any way to optimize it?
Share: More
------ Solution --------------------
It seems that you want to optimize your SQL. Index, cache
------ Solution --------------------
2 mb 6sec is not a very slow, but a little slow
You can cache the query results on the homepage to minimize the impact of database queries.
If the effect is not obvious, it indicates that your page layout is unreasonable and there are too many nested pages.
------ Solution --------------------
Cache the homepage. If dynamic data is used, ajax requests are used. Create necessary indexes