[Virtuoso-users] Stored procedures vs. dynamic queries

2010-03-01 Thread Alexander Sidorov
Hello! Is there any significant performance difference between stored procedures and dynamics queries in Virtuoso (for example, Microsoft SQL Server caches execution plans for dynamic queries as good as for stored procedures). Regards, Alexander

Re: [Virtuoso-users] Complex search based on Virtuoso Free Text Search

2010-03-01 Thread Alexander Sidorov
Hi Nathan, I combined your suggestion about summing scores using aggregation function and Orri Erling's ideas from this postand got very simple basis from my search engine: SELECT ?eventUri WHERE { ?eventU

[Virtuoso-users] Improve Free text indexing speed

2010-03-01 Thread Marc-Alexandre Nolin
Hello, I've created a new triplestore and created the free text index before starting to load the triples. I've load approximatively 4 billions triples in less than 2 days using TTLP. However, the free text index wasn't there. So the problem might be related to this situation (http://docs.openlink

Re: [Virtuoso-users] Complex search based on Virtuoso Free Text Search

2010-03-01 Thread Alexander Sidorov
P. S. At the moment I'm trying to combine all these approaches and integrate them into my search engine :) 2010/2/28 Nathan > Nathan wrote: > > > > SELECT DISTINCT ?s (sum(?oscore)) as ?finalWeight WHERE { > > { select ?s (xsd:integer( ?oscore * 1.4 )) as ?weight where { > > ?s ?o . ?o bif:con

Re: [Virtuoso-users] Complex search based on Virtuoso Free Text Search

2010-03-01 Thread Alexander Sidorov
Hi Nathan, Thank you very much! You helped me significantly. After your message receiving I googled more about IRI:RANK and bif:contains and found some interesting information: 1. Orri Erling's article "More On Parallel RDF/Text Query Evaluation"

Re: [Virtuoso-users] 6.1.0: README: getting started: command line isql example: inconsistent port 1112?

2010-03-01 Thread Tim Haynes
Nathan wrote: also worth noting that people should use the isql bundled with virtuoso and not the standard one which is often found on linux boxes - that's quite a gotcha! I have made this a FAQ: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSMake ~Tim -- Tim Haynes Product Developm

[Virtuoso-users] CORRECTION: Connections threshold for VOS

2010-03-01 Thread Kingsley Idehen
Kingsley Idehen wrote: Alexander Sidorov wrote: Hi Kingsley, Sorry, I didn't understand your last sentence. What do you mean by "Re. Cloud we are reevaluating the current threshold now that we have v6.1 released in both closed and open source variants."? Meaning, there was a time we h

Re: [Virtuoso-users] Programmatically putting RDFs into Virtuoso

2010-03-01 Thread Tim Haynes
(Oops, previous version sent too soon) Rameswara Sashi Kiran Challa wrote: I want to programmatically (in Java) put the RDF files I get, into virtuoso. I am planning to use HTTP put. I could make a system call, use curl and do it on Unix. How could I do it on Windows ? There's a load of way

Re: [Virtuoso-users] How to start ./virtuoso-t with a non-forked/daemonized parameter?

2010-03-01 Thread Tim Haynes
Ceriel Jacobs wrote: Hi list, Correctly starting Virtuoso on Mac OS X with launchd (a .plist) fails. Virtuoso-t starts, that is not the problem. But the process cannot be controlled any further with launchctl commands. When looking further into launchctl, you see that the originally start pr

Re: [Virtuoso-users] Programmatically putting RDFs into Virtuoso

2010-03-01 Thread Tim Haynes
Rameswara Sashi Kiran Challa wrote: I want to programmatically (in Java) put the RDF files I get, into virtuoso. I am planning to use HTTP put. I could make a system call, use curl and do it on Unix. How could I do it on Windows ? There's a load of ways to insert RDF into Virtuoso: http://v

Re: [Virtuoso-users] Storing uris

2010-03-01 Thread Tim Haynes
Alexander Sidorov wrote: Hi Nathan, But Virtuoso will do all right even if I save uri value as literal "http://a.uri"; :) For example: scienceConferenceUri typeOfScience "http://uri#mathematics"; When I save object properties values I always see some kind of dualism :) On the one hand, obje

Re: [Virtuoso-users] upload rdf turtle file in windows

2010-03-01 Thread Hugh Williams
Hi Madhu, On Windows you need to escape the windows "\" directory delimiter which is special character with a double slash "\\" as follows: ld_dir('C:\\Users\\madsaan\\Desktop\\vos6-win32-20100209\\virtuoso-opensource\\vad\\sider.ttl','sider.ttl','http://sider.com#'); Or change the wi

Re: [Virtuoso-users] Error reports

2010-03-01 Thread Nathan
Hi Peter! Peter Ansell wrote: > Hi Nathan, > - Original Message >> From: Nathan >> To: Virtuoso Users List >> Sent: Mon, 1 March, 2010 11:30:58 AM >> Subject: [Virtuoso-users] Error reports >> >> Hi All, >> >> Just a quick update on some "new to me" errors; >> >> 40001 Error SR172: Tra

[Virtuoso-users] upload rdf turtle file in windows

2010-03-01 Thread Madhuvanthi Sankaranarayanan
Hi, I am trying to upload turtle file (18kb) into virtuoso using the following instructions: http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoaderExampleSingle the dirsallowed param in my virtuoso.ini file is as follows: DirsAllowed = ., ../vad So i put my file sider.ttl inside v

Re: [Virtuoso-users] Error reports

2010-03-01 Thread Peter Ansell
Hi Nathan, - Original Message > From: Nathan > To: Virtuoso Users List > Sent: Mon, 1 March, 2010 11:30:58 AM > Subject: [Virtuoso-users] Error reports > > Hi All, > > Just a quick update on some "new to me" errors; > > 40001 Error SR172: Transaction deadlocked I used to get this r

[Virtuoso-users] Error reports

2010-03-01 Thread Nathan
Hi All, Just a quick update on some "new to me" errors; 40001 Error SR172: Transaction deadlocked and another one (which i lost) which basically said "Generated SQL more than 1 lines" which I was getting frequently when SPARUL inserting 2000-5000 triples; I've since lowered all sparul querie