@tsteur opened this Issue on October 21st 2012 Owner

Loading an evolution graph takes a very long time. Sometimes > 1 Minute. In comparison a normal graph takes only 1 or 2 seconds.

We should profile what takes that long and optimize this. For example the queries which are performed while creating the graph.

Evolution Graph should also load in 1-3 seconds if possible. Otherwise it takes too long to display the graph in Piwik Mobile since it also takes some time to download the graph (depending on the current Internet connection on the mobile device)

@mattab commented on October 22nd 2012 Owner

A bug caused by slow Row Evolution was reported in #3363

@mattab commented on October 27th 2012 Owner

See also #3465 to do at same time

As related to #3464, @capedfuzz would you be interested in profiling with xhprof and seeing if we could quick-fix this slowness? let's not spend more than 3 hours on this, but hopefully in this short time we can find a solution to make Static Historical Graph super fast.

This would be a big plus for PIwik Mobile, which could then start using these graphs (they are disabled until they can be made faster). Thanks!

@mattab commented on December 17th 2012 Owner

For example this graphs URL takes 3-4 seconds to generate but ideally should take 1 second max (if possible).

@diosmosis commented on March 13th 2013 Member

Optimization Idea: DataTableManipulator loads subtables one at a time. It's possible to load them all at once however (which is done when expanded=1), then access the DataTable in DataTable_Manager. Since manipulators are run after the main request though, we'll want to make sure we're not accessing the subtables twice (otherwise memory consumption will go up).

@mattab commented on February 1st 2014 Owner

btw is this still a problem ? Or are graphs loading OK on the mobile app now?

@tsteur commented on January 16th 2018 Owner

I think this issue can be closed. feel free to reopen if still a problem

This Issue was closed on January 16th 2018
Powered by GitHub Issue Mirror