WFS Neptune Performance

[bermud]

Query 16: Find all roads where the geography name is 'Pr- 20', and where the feature unique identifier is S1200

Took 5 minutes to load all the data.

[nmco]

I tried the following query matching the described query criterion:

http://cloudsdi.geo-solutions.it/geoserver/geoedge/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=geoedge:road_c&cql_filter=zi005_fna='Pr- 20' AND fufi='S1200'

It return the following 16 features:

road_c.207382
road_c.213099
road_c.213665
road_c.245
road_c.1484
road_c.1575
road_c.2962
road_c.3590
road_c.3698
road_c.4383
road_c.4900
road_c.54260
road_c.76637
road_c.81688
road_c.81693
road_c.104451

The request takes about ~ 500 milliseconds to execute (an index can be created to speed up the execution of the SQL query used to query the PostgreSQL database if needed):

nuno@nuno-P7xxDM-G /tmp $ wget "http://cloudsdi.geo-solutions.it/geoserver/geoedge/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=geoedge:road_c&cql_filter=zi005_fna='Pr- 20' AND fufi='S1200'" -O out.xml
--2018-08-27 17:45:35--  http://cloudsdi.geo-solutions.it/geoserver/geoedge/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=geoedge:road_c&cql_filter=zi005_fna='Pr-%2020'%20AND%20fufi='S1200'
Resolving cloudsdi.geo-solutions.it (cloudsdi.geo-solutions.it)... 52.10.139.37
Connecting to cloudsdi.geo-solutions.it (cloudsdi.geo-solutions.it)|52.10.139.37|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
Saving to: ‘out.xml’

out.xml                       [   <=>                               ]  78,22K   167KB/s    in 0,5s    

I will give it a try with QGIS to understand what is going on.