Re: [Virtuoso-users] "Simple freetext search" with SPARQL / jena

2008-09-02 Thread Drew Perttula
Kjetil Kjernsmo wrote: Up to now, we've been running Jena, and the way we have solved this problem is to concatenate all literals, create a "sub:literals" property, and then freetext search this property. It works, but queries that returns a few hundred entries usually takes around 40 seconds.

Re: [Virtuoso-users] DBpedia and Virtuoso SPARQL Query

2008-04-24 Thread Drew Perttula
On 21 Apr 2008, at 14:40, robl wrote: SELECT * FROM pages WHERE page_title LIKE "Queen%Elizabeth" This would perform a case insensitive match on Queen(anything) Elizabeth (at least in mySQL). ... Is there quick way to do what I want ? Are there any indexes I could apply to improve thi

[Virtuoso-users] dateTime roundtrip loses formatting and timezone

2008-02-13 Thread Drew Perttula
In VOS 5.0.5, I used ttlp to read from an .nt file with a line like this: "2008-05-30T23:36:28.72-07:00"^^. Then I ran this query over http: SELECT ?o WHERE {