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:
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
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