Hi Marcelo, What is the version of version being used, need the exact version by running the commmand “virtuoso-t -?” from command line ?
I presume you have tuned your Virtuoso instance for the hardware it is running
on as detailed at:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning
Please also provide:
1. The output of running the “status(‘’);” command from isql so we can see the
status of the server before and while the query is being run.
2. The output of running the “top” command to see the memory usage and CPU
consumption of the server
3. The compiler query execution plan using the Virtuoso explain() function as
detailed at:
http://docs.openlinksw.com/virtuoso/fn_explain.html
4. The sparql_to_sql_text() output for the query so we can see what SQL it is
being transformed to as detailed at:
http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 19 Dec 2012, at 18:32, Marcelo Aliquintuy wrote:
> 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
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ 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
