Re: [Virtuoso-users] Speedup datediff query

Thanks Ivan, this is way faster! Best, Dimitris On Mon, Aug 12, 2013 at 9:35 PM, Ivan Mikhailov wrote: > Hello Dimitris, > > I'd rephrase the query, magin the filter index-friendly: > > SELECT ?wiki, ?dbp, bif:datediff('second', xsd:DateTime(?extracted), > now()) AS ?secondsAgo > FROM

Re: [Virtuoso-users] Speedup datediff query

Hello Dimitris, I'd rephrase the query, magin the filter index-friendly: SELECT ?wiki, ?dbp, bif:datediff('second', xsd:DateTime(?extracted), now()) AS ?secondsAgo FROM WHERE { ?wiki foaf:primaryTopic ?dbp . ?dbp dcterms:modified ?extracted . FILTER ( ?extracted > b

[Virtuoso-users] Speedup datediff query

Hi, I am experimenting with a new "latest updates" display for DBpedia Live in Dutch where I get the list live from Virtuoso with javascript http://live.nl.dbpedia.org/statistics/statistics.html I am storing the timestamp of all the extracted item as a dcterms:modified on the dbpedia resource and