Inconsistent page times

[luke.lukas]

Hello,

 

I've enabled debug mode, and my website is showing that random queries that should take < 10ms to load, are supposedly taking much longer.

Example query: SELECT SQL_NO_CACHE * FROM `gZ5dA1fv7y_country_lang` WHERE `id_country` = 17

from /src/Adapter/EntityMapper.php:84, says 40000~ms load time, but it's obviously incorrect as the page loaded in 3s~.

 

Loading a page multiple times can return results such as 1.2s, 2s, 3.4s load times. Shouldn't page loads be somewhat consistent if the website isn't experiencing heavy traffic?

 

Apc Cache is disabled since it ruins Prestashop Checkout, other forms of caching are enabled such as smarty,js/css minified etc.

 

Thanks

Edited December 20, 2022 by luke.lukas (see edit history)