Re: [Virtuoso-users] Slow reply when adding an extra restriction

2010-09-14 Thread Ivan Mikhailov
Hello Frode, The difference means that the optimizer overestimated the selectivity of the new triple pattern and placed it before free-text. There are two typical fixes for such cases: an accurate one and a "dirty hack". The accurate is possible if you know that some of triples in question are al

Re: [Virtuoso-users] count triples per day

2010-09-14 Thread Tim Haynes
On 26/08/2010 16:08, Camila Dias wrote: > Hello , > > How can i see how many triples per day i have? Hi, It rather depends what you mean. I expect the key query is select count(*) from rdf_quad; and then it's up to you how you'd like it presented: a) use the scheduler to make things h

Re: [Virtuoso-users] SPARQL endpoint traffic logging

2010-09-14 Thread Tim Haynes
On 19/08/2010 14:04, Aldo Bucchi wrote: > Is there a way to enable logs for all SPARQL queries hitting an endpoint? Hi, One option that comes to mind: virtuoso.ini [HTTPServer] HTTPLogFile=somefile (More at http://docs.openlinksw.com/virtuoso/dbadm.html) HTH, ~Tim -- Tim Haynes Product Deve

Re: [Virtuoso-users] Paths in compiled from source Virtuoso on Ubuntu Lucid

2010-09-14 Thread Tim Haynes
On 12/07/2010 23:08, Peter DeVries wrote: > I decided to try to do the source install of the latest version of Virtuoso > Open Source on Ubuntu Lucid. > > * This is different than installing *virtuoso-opensource* via the package > manager. > > Following the default configuration using default pat

[Virtuoso-users] Slow reply when adding an extra restriction

2010-09-14 Thread Frode Roxrud Gill
I am preparing for an upgrade to Virtuoso 6.1.2, and during testing I see that two almost identical queries give very different response time - the one with an extra restriction takes a lot longer(!) to complete. At http://msoneutv.computas.no:8890/sparql >, copy&pasting the following query gives

Re: [Virtuoso-users] complex sparql query problem

2010-09-14 Thread Florian Kleedorfer
On 13.9.2010 18:19, Hugh Williams wrote: Hi Florian, You mentioning trying two approaches to dumping the data but only provide details of one below, what is the other method you tried and did this work ? The other approach I tried for dumping data used the RDF_QM_TREE_DUMP procedure, with thi