3

as per our architecture, we have a web server(Apache) running on one machine and my database(MySQL) running on different machine. The communication between these two machines in over internal network (without any firewall or any gateway).

We have a database heavy site with around 3000 products and the number is expected to grow. But the problem is that the site is taking too much of time to load (~30 sec). the waterfall diagram in browser shows that first response from server takes around 24-25 seconds and then the complete page loads in 30 seconds.

  1. Images of the products are not heavy and also there is no need for CDN as the server location is in same geographical area.

  2. the site is hosted on a private cloud

  3. the score on GTMetrix is 96%

Any pointers to debug the issue will be much appreciated

Improve this question
8
  • First thing to check are caches, make sure they’re enable and are wirking (ie. They are saved and read from the storage).
    – Zefiryn
    Sep 2, 2019 at 17:35
  • We have checked cache have already enabled.Please suggest
    – Baljit Magento 2
    Sep 2, 2019 at 17:55
  • please run profiler, to make sure magento code is ok.
    – MagenX
    Sep 2, 2019 at 18:00
  • if you have cache enabled and production mode bin/magento deploy:mode:show - make sure it works, reset php opcache. this will reload env.php settings
    – MagenX
    Sep 2, 2019 at 18:02
  • Thank you quick reply we have enabled cache as well as website in production mode but website speed are same.please help
    – Baljit Magento 2
    Sep 2, 2019 at 19:07

1 Answer 1

Reset to default
1

There are some points which you should have to keep always in mind such as:

a) Is file reading taking time : If you do not have SSD then some time can be lost.

b) Collect sql queries( As this can be one of the major cause ) that were fired with page cached. Its our experience that due to improper configuration or some non standard block code or due to some Modules the blocks are no cached but generated each time. Here make sure that not more then 100 sql queries are getting fired.An uncached page might take almost a 1000 plus queries but a properly coded page will no 0 to 100 queries.

c) Some third party request was fired and code waiting for that response till the request times out.

Improve this answer
1
  • We have found a solution regarding the Speed issue we have to disable reward point extension its load js every time
    – Baljit Magento 2
    Jan 10, 2020 at 6:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.