STCN uniformity issue and slow retrieval

[linguistcrg]

While performing a search of the word "almanac", instead of getting this output: Performing query: almanac

I get the following output:

Performing query: prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix schema: <http://schema.org/>
prefix owl: <http://www.w3.org/2002/07/owl#>
select ?s ?name where
{
  ?s ?p ?o .
  ?s <http://schema.org/name> ?name .
  ?s schema:mainEntityOfPage/schema:isPartOf <http://data.bibliotheken.nl/id/dataset/stcn> .
  FILTER (regex(?o, "almanac","i"))
}
order by ?s

I still get the list of results right afterwards, but it takes too long.

[tijmenbaarda]

STCN is very slow indeed, too slow. This has to do with the regex filter in the SPARQL query.

There might be two solutions:

• Find an alternative to the regex filter, or find a way to make it quicker. @jgonggrijp : do you know if this is possible?
• Use the alternative REST API, which provides faster search but offers output in raw marc21 and JSON: https://data.cerl.org/stcn/_api#/default/get_stcn__search

[jgonggrijp]

• Find an alternative to the regex filter, or find a way to make it quicker. @jgonggrijp : do you know if this is possible?

Probably not, but please do give me pointer to the code in question. I might come up with an idea when I see it.