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
Related to #4253
Skerbater, do you agree that a new preference like "no ajax query in segment editor" would do the trick?
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.