@RMastop opened this Issue on April 24th 2017 Contributor

In an environment, having around 90k pageviews per month, the flattened entry page report and exit page report take some time to be generated:

selecting top 10, takes around 10 seconds,
selecting top 50, takes around 19 seconds,
selecting the default top 100, takes around 22 second

If one would compare this to the pages report top 100 plattened report, it loads in around 4 seconds. In the past the flattened pages report were slow but the speed of those report was improved at some point (I don't recall what commit caused the improvements).

Could the Entry page and Exit page report be a candidate for the same loadtime improvements?

@tassoman commented on April 13th 2018 Contributor

We happy updated to Matomo 3.2.0 in php 7.0 fpm environment by Centos7 with OpCache enabled.
Running a dualhead application installation on a single instance of MySql 5.7 DBMS.
Counting in total 6.2 millions actions last month.

Sometimes our web editors need to report theire website activity, flattened entry and exit pages actions included.

We ran in the same issue. more, our Matomo installation hangs giving back errors because php-fpm killed by SIGSEGV. It happens also asking for daily flattened entry/exit page reports.

So I've raised execution parameters to 1GB RAM amount and time to 120 sec but PHP it's still going on Fatal Error because of Allowed memory size exausted in Line 1333 of DataTable.php (links properly to v2.3.0 tag file's version)

I ask you help because SysOps feels we're running already an amount of resoruces.
Can be better? Others reports are speedy flawless ok.

Thank you for caring, bye!

@tassoman commented on June 1st 2018 Contributor

Ciao @mattab , I'm wondering if there are any news on this topic.
Do you think this issue can gain some popularity in development team in the next future?

@mattab commented on June 1st 2018 Member

Hi @tassoman Hard to say, probably not, unless we experience the problem ourselves or one of our customers...

@tassoman commented on June 4th 2018 Contributor

Thank you for fast response, I understand your point of view. Anyway I hope some company might be interested tho. :1234:

@tsteur commented on June 4th 2018 Member

We can reproduce this for month as well. Takes quickly 20 seconds even when just viewing 50 rows as @RMastop mentioned.

I only had a quick look in the code but couldn't find anything obvious except maybe https://github.com/matomo-org/matomo/blob/3.5.1/plugins/Actions/DataTable/Filter/Actions.php#L65-L67 could you try to remove those 3 lines to see if it works better?

Powered by GitHub Issue Mirror