[gdal-dev] VirtualOGR with Sqlite

[Even Rouault]

> 2) My http debugger showed that a getfeature request was sent to the WFS
> without any filters and the request is really really slow so I assumed it
> was a full download. Try:
> 
>  CREATE VIRTUAL TABLE testpdk1 USING VirtualOGR('wfs:
> http://geoservice.plansystem.dk/wfs
> ',0,'pdk:theme_pdk_kommuneplanramme_vedtaget_v');
> 
> SELECT * FROM testpdk1 LIMIT 10;
> 

Ok, I reproduce. But this is an issue of that particular WFS server that, 
apparently, must generate the full GML document before sending it to the 
client.

Other WFS servers (for example 
WFS:http://demo.opengeo.org/geoserver/wfs?VERSION=1.1.0) have streaming 
capabilities, that the OGR WFS driver is now able to use to retrieve features 
as soon as they are streamed from the server to the client.