Re: [Virtuoso-users] Making REGEX filters fast

2016-02-22 Thread Hugh Williams
Hi Daniel, I would not expect STRSTARTS to be any faster than REGEX as neither are indexed. The Virtuoso bif:contains function which is available in both open source and commercial does have a Full Text index which makes it much faster for string searches. So you can use something like:

[Virtuoso-users] Making REGEX filters fast

2016-02-22 Thread Davis, Daniel (NIH/NLM) [C]
Is there a way to make FILTER(REGEX(?label, 'Insurance, Health/utilization', 'I')) queries fast? I can see that REGEX is going to require a linear scan of the data, and that there are stored functions that do the matching. Will STRSTARTS be able to work quickly? Does the database collation al