Hi.
I got 100% cpu with virtuoso with query that have bif:search_excerpt,
bif:vector in sparql endpoint or isql command line
the query is:
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX lom: <http://www.cc.uah.es/ie/ont/lom2owl#>
PREFIX cc: <http://www.toeska.cl/ns/contentcompass/ontology/v1.0#>
select ?s, max(?sc) AS ?rank, ?type,
(bif:search_excerpt(bif:vector('"niño"'),?o)) as ?c2, ?label, ?cfUrl, ?cfFormat
FROM <urn:contentcompass:graph:lo>
where {?s ?p ?o . ?s rdf:type ?type .
?o bif:contains '"niño"' OPTION (score ?sc) .
optional {?s lom:hasTitle ?label .
?s cc:describes ?cf .
?cf lom:isLocated ?cfUrl .
?cf lom:hasFormat ?cfFormat} .
filter (?type in
(<http://www.toeska.cl/ns/contentcompass/ontology/v1.0#Content_Object>))
}
GROUP BY ?s ?type ?cfUrl ?o ?label ?cfFormat
ORDER BY DESC (?rank)
limit 7 offset 0
if i remove "(bif:search_excerpt(bif:vector('"niño"'),?o))" part the query
works fine but with them takes 100% CPU :o.
return without "(bif:search_excerpt(bif:vector('"niño"'),?o))":
s rank type label cfUrl cfFormat
urn:co:f3b0574b-7ff6-aeee-1bce-3ecde6569685 30
http://www.toeska.cl/ns/contentcompass/ontology/v1.0#Content_Object "Defensa de
los derechos del niño : antecedentes históricos desde la perspectiva de
Chile"@es
"http://www.memoriachilena.cl/archivos2/pdfs/MC0030467.pdf"^^<http://www.w3.org/2001/XMLSchema#string>
"text/pdf"^^<http://www.w3.org/2001/XMLSchema#string>
urn:co:f3b0574b-7ff6-aeee-1bce-3ecde6569685 24
http://www.toeska.cl/ns/contentcompass/ontology/v1.0#Content_Object "Defensa de
los derechos del niño : antecedentes históricos desde la perspectiva de
Chile"@es
"http://www.memoriachilena.cl/archivos2/pdfs/MC0030467.pdf"^^<http://www.w3.org/2001/XMLSchema#string>
"text/pdf"^^<http://www.w3.org/2001/XMLSchema#string>
urn:co:f3b0574b-7ff6-aeee-1bce-3ecde6569685 24
http://www.toeska.cl/ns/contentcompass/ontology/v1.0#Content_Object "Defensa de
los derechos del niño : antecedentes históricos desde la perspectiva de
Chile"@es
"http://www.memoriachilena.cl/archivos2/pdfs/MC0030467.pdf"^^<http://www.w3.org/2001/XMLSchema#string>
"text/pdf"^^<http://www.w3.org/2001/XMLSchema#string>
urn:co:f3b0574b-7ff6-aeee-1bce-3ecde6569685 22
http://www.toeska.cl/ns/contentcompass/ontology/v1.0#Content_Object "Defensa de
los derechos del niño : antecedentes históricos desde la perspectiva de
Chile"@es
"http://www.memoriachilena.cl/archivos2/pdfs/MC0030467.pdf"^^<http://www.w3.org/2001/XMLSchema#string>
"text/pdf"^^<http://www.w3.org/2001/XMLSchema#string>
urn:co:f3b0574b-7ff6-aeee-1bce-3ecde6569685 20
http://www.toeska.cl/ns/contentcompass/ontology/v1.0#Content_Object "Defensa de
los derechos del niño : antecedentes históricos desde la perspectiva de
Chile"@es
"http://www.memoriachilena.cl/archivos2/pdfs/MC0030467.pdf"^^<http://www.w3.org/2001/XMLSchema#string>
"text/pdf"^^<http://www.w3.org/2001/XMLSchema#string>
When use key "nino" o "niño" takes CPU, i use XAnyNormalization option in
virtuoso.ini too.
..
[I18N]
XAnyNormalization = 3
..
Best regards!
--
Marcelo Aliquintuy
87433162
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users