Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-10 Thread Robbet
Hi Ivan, thank you! Looks gut ... First one seems to work as a Sparql query. syntax error at bif:strstr before ( FILTER ( BOUND(bif:strstr (?label, ?title) ) But it works without the BOUND keyword. I'm new to Virtuoso and SQL / SPARQL environment and try to compare small buch of

Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-10 Thread Kingsley Idehen
On 6/10/11 1:10 AM, Robbet wrote: Hi Ivan, thank you! Looks gut ... First one seems to work as a Sparql query. syntax error at bif:strstr before ( FILTER ( BOUND(bif:strstr (?label, ?title) ) But it works without the BOUND keyword. I'm new to Virtuoso and SQL / SPARQL environment and

Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-10 Thread Robbet
Hi Kingsley, changed NumberofBuffers and MaxDirtyBuffer to 4GB recommendation. Did i miss something? Dunno if it's only rely in the given hardware or if my query causes the slowdowns. Best regards, Robert On 10.06.2011 02:20, Kingsley Idehen wrote: On 6/10/11 1:10 AM, Robbet wrote: Hi

Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-10 Thread Kingsley Idehen
On 6/10/11 1:28 AM, Robbet wrote: Hi Kingsley, changed NumberofBuffers and MaxDirtyBuffer to 4GB recommendation. Did i miss something? Dunno if it's only rely in the given hardware or if my query causes the slowdowns. If after doing that you don't have improvements. We are down to DBMS size

Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-10 Thread Hugh Williams
Hi Robbet, What are your actual NumberOfBuffers and MaXDirtyBuffer settings for your 4GB memory system, I presume those recommended in the Virtuoso Performance Tuning guide at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning Which are:

Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-10 Thread Robbet
Hi, yes, i confirm both values. Best regards, Robert On 10.06.2011 04:02, Hugh Williams wrote: Hi Robbet, What are your actual NumberOfBuffers and MaXDirtyBuffer settings for your 4GB memory system, I presume those recommended in the Virtuoso Performance Tuning guide at:

Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-10 Thread Ivan Mikhailov
On Fri, 2011-06-10 at 02:10 +0200, Robbet wrote: Hi Ivan, thank you! Looks gut ... First one seems to work as a Sparql query. syntax error at bif:strstr before ( FILTER ( BOUND(bif:strstr (?label, ?title) ) But it works without the BOUND keyword. I'm sorry, there should be

Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-10 Thread Robbet
Hi Ivan, i'll try this. My whole query would be like: /Select ?title ?label v Where {?s dc:title ?title; dc:created ?created./ // /?dbpedia rdfs:label ?label FILTER (bif:strcontains (?title, ?label))/ /?dbpedia foaf:name ?name }

[Virtuoso-users] RDF geo queries in open source edition

2011-06-10 Thread Babis Doulaverakis
Hello, I am using the open source edition for Virtuoso but I am unable to run the procedure RDF_GEO_FILL(); The server responds with the message  Undefined procedure DB.DBA.rdf_geo_fill The same happens when I try to use st_point. When I issue the query  SELECT st_point(0,52)  as in the manual,

Re: [Virtuoso-users] RDF geo queries in open source edition

2011-06-10 Thread Ivan Mikhailov
Hello Babis, Sorry, geospatial things are in commercial version only. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Fri, 2011-06-10 at 15:01 +0100, Babis Doulaverakis wrote: Hello, I am using the open source edition for Virtuoso but I am unable to run the

Re: [Virtuoso-users] RDF geo queries in open source edition

2011-06-10 Thread Hugh Williams
Hi Babis, This feature is not available in the Virtuoso open source product as it is a commercial product only feature. See the following Feature comparison matrix between the open source and closed source (commercial) products to see the differences between them:

Re: [Virtuoso-users] Clear graph

2011-06-10 Thread Alexander Sidorov
Hi Hugh, I forgot about that discussion and it really looks like the same problem. Unfortunately I have no idea how to execute define sql:log-enable NNN before the query - it doesn't run. Virtuoso 06.01.3127 About 30kk of triples. I am pretty sure my query calculates triples count inside a

Re: [Virtuoso-users] Clear graph

2011-06-10 Thread Ivan Mikhailov
Hello Alexander, All DEFINE pragmas are placed right into the SPARQL statement. They're not in a separate statement, they're part of SPARQL statement. If it's via web-interface then they're at the very beginning of the statement, if it's via ISQL or SPARQL is a part of an bigger SQL query or

Re: [Virtuoso-users] Clear graph

2011-06-10 Thread Hugh Williams
Hi Alexander You can turn transactions off and then back on using the log_enable() function directly as: log_enable(3,1); SPARQL CLEAR GRAPH graph-name; or as a pragma in the specified query as: SPARQL DEFINE sql:log-enable 3 CLEAR GRAPH graph-name; or you can