Hi all,

I loaded geonames(40 million triples) into Fuseki and I indexed the data
into lucene.

The query below takes 4 seconds to execute. While a similar SQL one into
postgis takes 13 ms.

PREFIX spatial: <http://jena.apache.org/spatial#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?place
{
    ?place spatial:withinCircle (32.55668 -117.12865    1  "km"  ) .


}

SQL

select  geonameid from geoname where ST_Intersects(the_geom,
ST_Buffer(ST_SetSRID(ST_MakePoint(-117.12865, 32.55668 ),4326)::geography,
1000)::geometry)

Do I need to make any extra configuration on Fuseki to improve the
performance?


Best,

-- 
Senior Data Scientist
Geophy
www.geophy.com

Nieuwe Plantage 54-55
2611XK  Delft
+31 (0)70 7640725

1 Fore Street
EC2Y 9DT  London
+44 (0)20 37690760

Reply via email to