Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Row evolution of custom report #12132

Closed
eramirezprotec opened this issue Sep 28, 2017 · 5 comments
Closed

Row evolution of custom report #12132

eramirezprotec opened this issue Sep 28, 2017 · 5 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@eramirezprotec
Copy link
Contributor

eramirezprotec commented Sep 28, 2017

Hi! I developed a new report. It is associated with a dimension and it's all working "fine". The problem is when I click on the "Open row evolution", It takes TOO LONG to show the evolution graph. How can I make this run faster?

I don't know if (somehow) I have to archive each row of the report.

This is the aggregateDayReport method of the Archiver.php:

$archiveProcessor = $this->getProcessor();
$dataTable = new DataTable();
$dataTable->addRowsFromSimpleArray($visitsData); //$visitsData is a well formed array.
$serializedDataTable = $dataTable->getSerialized();
$archiveProcessor->insertBlobRecord(self::XXX_RECORD_NAME, $serializedDataTable);

aggregateMultipleReports method:

$archiveProcessor = $this->getProcessor();
$archiveProcessor->aggregateDataTableRecords(self::READINGSMAS_RECORD_NAME);

And this is my API.php:

$archive   = Archive::build($idSite, $period, $date, $segment);
$dataTable = $archive->getDataTable(Archiver::XXX_RECORD_NAME);
return $dataTable;
@sgiehl
Copy link
Member

sgiehl commented Sep 30, 2017

Row evolution loads a big bunch or archives to compare the data within. As long as all archives are built, there is nothing you can do about the performance of row evolution in your plugin.
Improvements therefor would be needed to be done in core.

@eramirezprotec
Copy link
Contributor Author

Thank you very much for taking the time to answer this issue, @sgiehl.

@mattab mattab closed this as completed Oct 16, 2017
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Oct 16, 2017
@eramirezprotec
Copy link
Contributor Author

eramirezprotec commented Feb 13, 2018

@sgiehl, I don't understand why the row evolution graph of the reports built by me are taking too long to be shown. Normal reports' row evolution graph like campaigns, referrers, etc., load really fast. Is there something I am missing that I should add to my Report? Or at the moment of archiving?

A normal Matomo report row evolution graph loads in less than 4 seconds; the row evolution graph of my reports takes more than 30 seconds (I'm getting a timeout, and I know I can increase that time, but I'm not interested, my goal is to load my reports evolution row as fast as Matomo's reports).

I hope there is something to do with this issue... I really need to load the row evolution in a short amount of seconds... thank you very much.

I'm using Matomo 3.2.0

@tsteur
Copy link
Member

tsteur commented Feb 13, 2018

I suggest to ask this in the forums as we usually don't answer such questions here. https://forum.matomo.org/c/plugins-platform

I would check if viewing the evolution report is still slow when you don't include today in the row evolution.

@eramirezprotec
Copy link
Contributor Author

@tsteur, I understand. I'm sorry.

It is still slow when I don’t include today in the row evolution. This is a big problem for me…

I asked on the forums: https://forum.matomo.org/t/row-evolution-takes-too-long-to-show-up/27203

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

4 participants