Re: [gdal-dev] ogr-pg: GetFeature() speed

2011-08-23 Thread Frank Warmerdam
On 11-08-23 04:57 AM, Martin Landa wrote: Hi, I have tested speed of random access to PostGIS features with simple testing application. // about 1e4 points poLayer = poDS->GetLayerByName("bridges"); nfeatures = poLayer->GetFeatureCount(); for (int fid = 1; fid< nfeatures;

Re: [gdal-dev] ogr-pg: GetFeature() speed

2011-08-23 Thread Even Rouault
Selon Martin Landa : I'm not shoked at all by the performance you see. I would have even expected it to be worse. Fetching 10 000 features in 5.6s, means 0.56 millisecond per feature. Not so bad. You have to pay the cost for a client/server dialog for each GetFeature() call whereas GetNextFeature(

[gdal-dev] ogr-pg: GetFeature() speed

2011-08-23 Thread Martin Landa
Hi, I have tested speed of random access to PostGIS features with simple testing application. // about 1e4 points poLayer = poDS->GetLayerByName("bridges"); nfeatures = poLayer->GetFeatureCount(); for (int fid = 1; fid < nfeatures; fid++) poFeature = poLayer->GetFeature(