Skip to content

Add segment conditions "Does not Start with" and "Does not end with"  #18009

@tomper00

Description

@tomper00

We have learnt the hard way that segments for URLs that use the citeras Contains and Does not contain has a very negative effect on the archiving performance, since both of them will generate MYSQL queries towards the visitor log that will not use an index.

Our solution was to rewrite a lot of these segments to use "Starts with" instead and this had a very good impact om our archiving in general.

We still have a few segments that use the "Does not contain" filer and fore these we do not really have a solution in place.

Adding the "Does not Start with" condition would really help our here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    EnhancementFor new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.c: Consistent Reports & Analytics UXFor bugs and features that make Analytics reporting UI behave more consistently.c: PerformanceFor when we could improve the performance / speed of Matomo.c: PlatformFor Matomo platform changes that aren't impacting any of our APIs but improve the core itself.c: SegmentsSegmentation and Segment editor related improvements and fixes.

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions