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:

Re: [Virtuoso-users] infrequent errors on parallel querying

2016-02-22 Thread Hugh Williams
Hi Andreas, Missed that you were running 4 Virtuoso instances, how is the query workload split across the 4 instances ? I noticed the following errors in all the logs during done attempt to restart: 09:23:02 ERROR: Unable to lock file ../var/lib/virtuoso/db/virtuoso.lck (Resource temporarily

[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