Re: [Virtuoso-users] List graphs in V5 and V6

Natan, > DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() > needs almost 100 seconds the first time and 20 seconds for consecutive > queries. > > select GRAPH_IRI from DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS_T ; > needs 20-50 seconds also The question is the number of graphs returned by the procedure, the speed

Re: [Virtuoso-users] List graphs in V5 and V6

Sebastian Hellmann wrote: > Hello, > > DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() > needs almost 100 seconds the first time and 20 seconds for consecutive > queries. > > select GRAPH_IRI from DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS_T ; > needs 20-50 seconds also strange.. wonder if it's another issue, runs

Re: [Virtuoso-users] List graphs in V5 and V6

Hello, DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() needs almost 100 seconds the first time and 20 seconds for consecutive queries. select GRAPH_IRI from DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS_T ; needs 20-50 seconds also Is there no better way that works right now? Let's say I create a an index starting w

Re: [Virtuoso-users] ODS vad daily builds

Hi Nathan, Kingsley pointed me here to get access to the latest ods vad builds (daily ones). Specific need atm would be for 1.63.38+ framework; however daily updates would be good as using virtuoso/ods pretty intensively at the minute. current install of virtuoso is 6.0.1 built 20091119 (y

Re: [Virtuoso-users] List graphs in V5 and V6

Hello Sebastian, The very next VOS release will contain special optimization for sparql select distinct ?g where { graph ?g { ?s ?p ?o }} Meanwhile you may use an built-in SQL procedure DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() that produce such a list. In next release, a variant of that procedure wil

Re: [Virtuoso-users] List graphs in V5 and V6

Sebastian Hellmann wrote: > Hello, > what is the fastest way to query for a list of graphs in the store > for the V5 and V6 series. I do not succeed to write a query that is > faster than 10 seconds. > > I'm testing it on http://db0.aksw.org:8890/sparql , the latest VOS 6 , > which has DBpedia l

[Virtuoso-users] ODS vad daily builds

Hi, Kinglsey pointed me here to get access to the latest ods vad builds (daily ones). Specific need atm would be for 1.63.38+ framework; however daily updates would be good as using virtuoso/ods pretty intensively at the minute. current install of virtuoso is 6.0.1 built 20091119 (yesterday); r

[Virtuoso-users] List graphs in V5 and V6

Hello, what is the fastest way to query for a list of graphs in the store for the V5 and V6 series. I do not succeed to write a query that is faster than 10 seconds. I'm testing it on http://db0.aksw.org:8890/sparql , the latest VOS 6 , which has DBpedia loaded and some OntoWiki graphs. I ev

[Virtuoso-users] Segmentation fault

Hi, Just to keep you informed on release 6.0.0 with Ubuntu 9.10: we get also segmentation faults when installing packages. E.g. the logging when trying to install "Framework": root@ubuntu:~# cd /usr/local/virtuoso-opensource/var/lib/virtuoso/db root@ubuntu:/usr/local/virtuoso-opensource/var/lib/vi

[Virtuoso-users] Bad query performance when selecting from two graphs

Hi, I have a SPARQL query which performes well when querying a single graph but "the estimated execution time exceeds the time limit of 400 (secs)" when querying two graphs. This is also true if the second graph is empty. Why is this the case / how can I fix this? Query A (performes well): SEL