Hi,

Can you use the debug mode, open the AJAX DEBUG panel, and look if you have some really slow query that can explain this ?

Regards

I also have very slow overall performance after upgrade to 9.4.1.1 from 9.4.1.0. I use Windows 2012 IIS and PHP 7.2 with Wincache enabled.

[2019-04-05 16:38:24] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"21@GCS3-5"}
[2019-04-05 16:38:25] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"36@GCS3-5"}
[2019-04-05 16:38:30] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"36@GCS3-5"}
[2019-04-05 16:38:47] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): exif_imagetype(_pictures/da/494_5bcf1b8d5bdda_min.jpg): failed to open stream: No such file or directory
Backtrace :
:
inc\document.class.php:1545 exif_imagetype()
front\document.send.php:72 Document::isImage()
{"user":"494@GCS3-5"}
[2019-04-05 16:38:59] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): exif_imagetype(_pictures/da/494_5bcf1b8d5bdda_min.jpg): failed to open stream: No such file or directory
Backtrace :
:
inc\document.class.php:1545 exif_imagetype()
front\document.send.php:72 Document::isImage()
{"user":"494@GCS3-5"}
[2019-04-05 16:45:05] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\updatecurrenttab.php:33 include()
{"user":"510@GCS3-5"}
[2019-04-05 16:45:36] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"489@GCS3-5"}
[2019-04-05 16:45:36] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"489@GCS3-5"}
[2019-04-05 16:45:42] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"22@GCS3-5"}
[2019-04-05 16:45:42] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"22@GCS3-5","mem_usage":"0.064", 1.00Mio)"}
[2019-04-05 16:45:45] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"36@GCS3-5"}
[2019-04-05 16:45:54] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"21@GCS3-5"}
[2019-04-05 16:45:59] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"443@GCS3-5"}
[2019-04-05 16:46:00] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"510@GCS3-5"}
[2019-04-05 16:46:02] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"22@GCS3-5"}
[2019-04-05 16:46:02] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"285@GCS3-5"}
[2019-04-05 16:46:14] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"21@GCS3-5"}
[2019-04-05 16:46:14] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"443@GCS3-5"}
[2019-04-05 16:46:23] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): exif_imagetype(_pictures/d1/6_5b348f4f4d4d1_min.jpg): failed to open stream: No such file or directory
Backtrace :
:
inc\document.class.php:1545 exif_imagetype()
front\document.send.php:72 Document::isImage()
{"user":"6@GCS3-5"}
[2019-04-05 16:46:24] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
front\document.send.php:33 include()
{"user":"6@GCS3-5"}
[2019-04-05 16:46:24] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): exif_imagetype(_pictures/ba/117_5be01295ab7ba_min.jpg): failed to open stream: No such file or directory
Backtrace :
:
inc\document.class.php:1545 exif_imagetype()
front\document.send.php:72 Document::isImage()
{"user":"6@GCS3-5","mem_usage":"0.002", 1.10Mio)"}
[2019-04-05 16:47:05] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"443@GCS3-5"}
[2019-04-05 16:47:40] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"181@GCS3-5"}
[2019-04-05 16:47:40] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"462@GCS3-5"}
[2019-04-05 16:47:42] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"22@GCS3-5"}
[2019-04-05 16:47:50] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"510@GCS3-5"}
[2019-04-05 16:47:51] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"489@GCS3-5"}
[2019-04-05 16:47:51] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"489@GCS3-5","mem_usage":"0.041", 1.05Mio)"}
[2019-04-05 16:48:15] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"36@GCS3-5"}
[2019-04-05 16:49:36] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"489@GCS3-5"}
[2019-04-05 16:49:39] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"21@GCS3-5"}
[2019-04-05 16:51:22] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): exif_imagetype(_pictures/da/494_5bcf1b8d5bdda_min.jpg): failed to open stream: No such file or directory
Backtrace :
:
inc\document.class.php:1545 exif_imagetype()
front\document.send.php:72 Document::isImage()
{"user":"494@GCS3-5"}
[2019-04-05 16:51:22] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): exif_imagetype(_pictures/da/494_5bcf1b8d5bdda_min.jpg): failed to open stream: No such file or directory
Backtrace :
:
inc\document.class.php:1545 exif_imagetype()
front\document.send.php:72 Document::isImage()
{"user":"494@GCS3-5"}
[2019-04-05 16:51:31] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): exif_imagetype(_pictures/da/494_5bcf1b8d5bdda_min.jpg): failed to open stream: No such file or directory
Backtrace :
:
inc\document.class.php:1545 exif_imagetype()
front\document.send.php:72 Document::isImage()
{"user":"494@GCS3-5"}
[2019-04-05 16:51:36] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): exif_imagetype(_pictures/da/494_5bcf1b8d5bdda_min.jpg): failed to open stream: No such file or directory
Backtrace :
:
inc\document.class.php:1545 exif_imagetype()
front\document.send.php:72 Document::isImage()
{"user":"494@GCS3-5"}
[2019-04-05 16:51:45] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): exif_imagetype(_pictures/da/494_5bcf1b8d5bdda_min.jpg): failed to open stream: No such file or directory
Backtrace :
:
inc\document.class.php:1545 exif_imagetype()
front\document.send.php:72 Document::isImage()
{"user":"494@GCS3-5"}
[2019-04-05 16:52:07] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): Invalid argument supplied for foreach()
Backtrace :
inc\session.class.php:616
inc\includes.php:54 Session::loadLanguage()
ajax\notifications_ajax.php:33 include()
{"user":"285@GCS3-5"}
[2019-04-05 16:52:26] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in C:\inetpub\wwwroot\glpi\inc\toolbox.class.php line 659
*** PHP Warning(2): count(): Parameter must be an array or an object that implements Countable
Backtrace :
inc\includes.php:101
ajax\notifications_ajax.php:33 include()
{"user":"36@GCS3-5"}

Hi,

Can you use the debug mode, open the AJAX DEBUG panel, and look if you have some really slow query that can explain this ?

Regards

Thanks for looking into this.

This is the result we got from AJAX DEBUG panel:
24 Queries took 0.038s

Longest query took 0.006s

Hi,
Ok. I will and will post results here.

/front/ticket.php

6406 Queries took 6.8880000000005s

Here is some Chrome profile recording I hope it may help:
Profile-20190408T092752.zip

Hi,

Chrome profiling will not help, as it will not give us any explaination about the time taken by the server to respond.

I am pretty sure that thoose 6406 queries are related to usage of plugins. Can you try to disable plugins and see if the problem persist? If the problem comes from one plugin in particular, then you should open a bug on plugin repository.

Regards

Hi,

Chrome profiling will not help, as it will not give us any explaination about the time taken by the server to respond.

I am pretty sure that thoose 6406 queries are related to usage of plugins. Can you try to disable plugins and see if the problem persist? If the problem comes from one plugin in particular, then you should open a bug on plugin repository.

Regards

Hi Cedric
No. We do not use plugins now. This was not happening with previous version with the same environment and no plugins too. We used plugins a long time ago with previous vertions and this performance issues start to happen with new MySQL ver 8.0.12 and PHP 7.3.1. I think its a caching problem but not sure= I have tryed to change PHP ver to 7.2 trough 7.0 and things was worst so I change it back to 7.3 where is is slow but works somehow.

@atanasag

Sorry, I was thinking you were talking about the initial problem of this issue (the performances on the home page).
To have less queries make on ticket page list, try to display less columns or less results.
And do not mix subject please. One issue is for one problem only.

@dyingtako

We fixed a lot of issues that explains performances issues. Please try with the nightly build to see if errors re fixed.

Yes we talk for Home screen but for others will post separate issues:

@atanasag in this list, check if one is long ?
If not, how many entities do you have ?

@atanasag in this list, check if one is long ?
If not, how many entities do you have ?

No. All of them runs fast - between 0.001 and 0.008
We have 545 Entities

Hi,
Chrome profiling will not help, as it will not give us any explaination about the time taken by the server to respond.
I am pretty sure that thoose 6406 queries are related to usage of plugins. Can you try to disable plugins and see if the problem persist? If the problem comes from one plugin in particular, then you should open a bug on plugin repository.
Regards

Hi Cedric
No. We do not use plugins now. This was not happening with previous version with the same environment and no plugins too. We used plugins a long time ago with previous vertions and this performance issues start to happen with new MySQL ver 8.0.12 and PHP 7.3.1. I think its a caching problem but not sure= I have tryed to change PHP ver to 7.2 trough 7.0 and things was worst so I change it back to 7.3 where is is slow but works somehow.

Hello @atanasag,
Are you using Wincache with PHP 7.3?
Just for information, Wincache is not yet compatible with PHP 7.3, but only PHP 7.2. See https://forums.iis.net/t/1239969.aspx?PHP+7+3
Question: where did you get Wincache for PHP 7.3?
Thank you,
Regards,
Tomolimo

Hi,
Chrome profiling will not help, as it will not give us any explaination about the time taken by the server to respond.
I am pretty sure that thoose 6406 queries are related to usage of plugins. Can you try to disable plugins and see if the problem persist? If the problem comes from one plugin in particular, then you should open a bug on plugin repository.
Regards

Hi Cedric
No. We do not use plugins now. This was not happening with previous version with the same environment and no plugins too. We used plugins a long time ago with previous vertions and this performance issues start to happen with new MySQL ver 8.0.12 and PHP 7.3.1. I think its a caching problem but not sure= I have tryed to change PHP ver to 7.2 trough 7.0 and things was worst so I change it back to 7.3 where is is slow but works somehow.

Hello @atanasag,
Are you using Wincache with PHP 7.3?
Just for information, Wincache is not yet compatible with PHP 7.3, but only PHP 7.2. See https://forums.iis.net/t/1239969.aspx?PHP+7+3
Question: where did you get Wincache for PHP 7.3?
Thank you,
Regards,
Tomolimo
@tomolimo
Hi,
No I dont use wincache i use Zendopcache. If I try to enable APCu with APC backward-compatible (latest possible vers for 7.3) extension thing gone worse. It loads very very slow in Assistance and Tickets and Homescreen more than 1 min. if I disable APCu and APC things work just slow 30-40 sec to load some tickets, and 15-20 to load home-screen if i click on a ticket i need to wait 40+ sec to open it. I have tryed to move to PHP 7.2 and use wincache but the things became worst.
Now I'm using latest bug-fixes and my ver is 9.4.2. I was unable to update prior disabling APCu extension.

Just want to let you know, I had the same issues after updating to glpi 9.4.2

https://forum.glpi-project.org/viewtopic.php?id=168971

PHP V7.3.3

Apache:
Server version: Apache/2.4.38 (Win64)
Apache Lounge VC15 Server built: Feb 28 2019 11:40:54

Zend opcache installed: 7.3.3 (256 MB)
APCU cache 5.1.17 (32MB)

I was able to solve it by updating my php to 7.3.5, released on the 1st of may (zend opcache is included so is also update to 7.3.5)

(Like described it seemed to be a caching issue, no slow query's and the first execution after a refresh was always slow).

Just to let you know.

Can confirm that upgrading to PHP 7.3.5 has significantly improved GLPI 9.4.2's performance. Still takes a bit longer than it used to, but it's within acceptable boundaries.

Setup:

Operating system: Windows NT WITS01 10.0 build 14393 (Windows Server 2016) AMD64
PHP 7.3.5 cgi-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bcmath, calendar, cgi-fcgi, ctype, curl, date,
dom, exif, fileinfo, filter, gd, gettext, hash, iconv, imap, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre,
pdo_mysql, pdo_sqlite, readline, session, soap, standard, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, zip, zlib)
Setup: max_execution_time="300" memory_limit="128M" post_max_size="32M" safe_mode="" session.save_handler="files"
upload_max_filesize="32M"
Software: Microsoft-IIS/10.0
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36
Server Software: mariadb.org binary distribution
Server Version: 10.3.14-MariaDB
Server SQL Mode:
Parameters: glpi@127.0.0.1/glpi
Host info: 127.0.0.1 via TCP/IP

Can confirm that upgrading to PHP 7.3.5 has significantly improved GLPI 9.4.2's performance. Still takes a bit longer than it used to, but it's within acceptable boundaries.

Setup:

Operating system: Windows NT WITS01 10.0 build 14393 (Windows Server 2016) AMD64
PHP 7.3.5 cgi-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bcmath, calendar, cgi-fcgi, ctype, curl, date,
dom, exif, fileinfo, filter, gd, gettext, hash, iconv, imap, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre,
pdo_mysql, pdo_sqlite, readline, session, soap, standard, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, zip, zlib)
Setup: max_execution_time="300" memory_limit="128M" post_max_size="32M" safe_mode="" session.save_handler="files"
upload_max_filesize="32M"
Software: Microsoft-IIS/10.0
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36
Server Software: mariadb.org binary distribution
Server Version: 10.3.14-MariaDB
Server SQL Mode:
Parameters: glpi@127.0.0.1/glpi
Host info: 127.0.0.1 via TCP/IP

I have been trying this and for me, it did not work. For my environment, the only configuration is with PHP 7.2 x64 NTS with WinCache 2.0.0.8 and APCu 5.1.17 and APCubc 1.0.5 that runs reasonably not frustrating.

Hi all,

We just merged an improvement that can affect performances on instances with lots of entities.
Could you test applying #5981 to see if it solves your performances issues ?

Regards

I was having these problems of slowness when using Mysql 8.0.16, while replacing with MariaDB 10.4.6 everything was fixed. I have noticed that some query cache options have been discontinued in this version of MySQL, I believe there is a relation.

Maybe we have some redundancy on some queries in homepage which performances are lowered due to query cache removal in MySQL8 (https://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/).

Hi @dyingtako @atanasag @callummoffat ,

Can you test with current 9.4 nightly to see if problem persists ?

Regards

No feedback from a while, closing.

Hi again,
This is still an issue even with 9.5.1 I'v updated yesterday.
I have changed PHP to 7.4 with Wincache 2.0.0.8 everything else but Home view and Tickets View works fast.