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

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

Reply via email to