Ard Schrijvers wrote:
It may work for you at the moment, but a query like '//*[jcr:like(fn:lower-case(@propertyName), '%article%')]' is *extremely* inefficient. using the jcr:like in combination with a prefix '%' will most certainly lead to very slow results when the number of hits grows (even for quite small repositories).
just a small clarification. jcr:like becomes inefficient when the number of distinct values for the property grows. if you only have a handful of distinct values for that property and assign them to one million nodes the query will still be efficient.
regards marcel
