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.
Hi @tomper00
Thanks for creating this suggestion. Yes, segments using a contain might impact the archiving performance significant.
I don't think we will have time to implement additional segment operators in the near future, but if you have some free capacities a Pull Request would be very welcome.