@quba opened this Issue on July 15th 2015 Contributor

Background

When we have a segment like segment=pageUrl=<a class='mention' href='https://github.com/subdomain'>@subdomain</a>.domain.com/en, Piwik executes a subquery to filter the data set. This query uses condition where name like %subdomain.domain.com/en%.

Problem

Everything works OK but the case is that Piwik executes the same query for each archiver query. In ideal case Piwik would query the action IDs only once and then cache it.

Performance use case

I think that this improvement would greatly improve Piwik performance, mostly for users who are using segments processed in realtime.

@mattab commented on July 15th 2015 Owner

Thanks @quba for suggestion!

Ideally we would have exact data to backup our feeling it would speed things up, ie. what is % time spent in sub-query VS the whole archiver query. If we cache the result of subquery, we know we'd save this % in each subsequent archiver query. Waiting for more data to know whether it's worth it before we schedule the issue

@mattab commented on September 28th 2015 Owner

see Cache segment subqueries using LIKE constraint #8850

This Issue was closed on September 28th 2015
Powered by GitHub Issue Mirror