Re: [Virtuoso-users] performance tuning

Hugh, I tried with the isql command line ensuring that the query is all on the same line: SQL> explain('prefix rdf: select distinct ?ontology from where{ ?term rdf:type ?ontology. } order

Re: [Virtuoso-users] performance tuning

Hi Erick, If you are executing from the isql commandl line then you most probably need to ensure the query is all on the same line as multiple lines will not be passed as one query to the server. Multiple lines would best in the Conductor Interactive SQL UI, which you could try also. B

Re: [Virtuoso-users] performance tuning

Hi Hugh, I tried to run both queries (first surrounded by the 'explain' command) and I've got the following error message: The statement execution did not return a result set. SQLState: 37000 Message: SQ074: Line 1: syntax error at 'rdf' before ':' I also tried without the 'explain' comm

Re: [Virtuoso-users] performance tuning

Hi Eric, We have been able to see the hangs you report with the sample queries below. Can you please provide the output of running the Virtuoso explain command against these 2 queries and provide this output. The explain command provides more details on the query execution plan with Vir

Re: [Virtuoso-users] Delete from SPARQL Endpoint

Hello Chuck, Did you set write permissions for "SPARQL" account? Say, by running grant SPARQL_UPDATE to "SPARQL"; via ISQL ? By default, SPARQL endpoint account has read-only access to data due to obvious security reasons. Best Regards, Ivan Mikhailov, OpenLink Software http://virtuoso.openlin

Re: [Virtuoso-users] performance tuning

Hugh, I the first example I sent, you have to change: has_evidence_code by has_evidence Thanks, Erick Hugh Williams wrote: Hi Erick, You have not provided some sample queries for which these performance issues are being encountered as requested in point 3 ? Best Regards Hugh Williams Op