60 second delays in loading SugarCRM 9

I have a SugarCRM 8.0.1 that runs perfectly.

I have 2 DIFFERENT SugarCRM 9.0.0 instances (Backups from OnDemand from 2 different customers of mine) abd have these huge 60 second delays while loading.  Both 9.0.0 instances have exactly the same delay so it can't be something wrong in the code.

I am using MySQL 5.7 and the latest possible Apache with PHP 7.1.

Parents
  • Are there strange things logged in the sugar log? 

    Did you already check if you can enable log slow queries en see what is happening? 

    As a last resort use xhprof for profiling local instances

    Are you using a dockerized environment? Maybe connection between de various dockers ( if you have a separate docker for mysql,apache,elasticsearch etc) is just slow?

    Is there some sort of caching enabled in the config(overide) that you haven't got on your local environment and those instances are trying to connect to it?    

Reply
  • Are there strange things logged in the sugar log? 

    Did you already check if you can enable log slow queries en see what is happening? 

    As a last resort use xhprof for profiling local instances

    Are you using a dockerized environment? Maybe connection between de various dockers ( if you have a separate docker for mysql,apache,elasticsearch etc) is just slow?

    Is there some sort of caching enabled in the config(overide) that you haven't got on your local environment and those instances are trying to connect to it?    

Children
No Data