@anonymous-piwik-user opened this Issue on January 13th 2014

Running v2.0.2
Database is approx 10gb.
When I go to create a new segment using the page url filter, it takes an incredibly long time to pre-fill the url list (Avg 5-10mins), effectively locking the table, resulting in locked transactions for the live stats data that is coming in. We're getting on average 5 hit per second during peak times. We don't want to go over 500 max connections on our database, which we max every time i try to add a new segment. Is there a way to not have the segment editor query the table for the prefilled url list so i can just specify the url i want to use? Thanks!
Keywords: Segment Editor Large Database

@gaumondp commented on January 13th 2014

Related to #4253

Skerbater, do you agree that a new preference like "no ajax query in segment editor" would do the trick?


@anonymous-piwik-user commented on January 13th 2014

Agreed... or remove it completely. Typically people already know what url value is that they want to segment. It's no problem when working with small data, but we are huge and continue to grow, so this is a problem.

@mattab commented on February 6th 2014 Owner

See #4253

This Issue was closed on February 6th 2014
Powered by GitHub Issue Mirror