[gdal-dev] postgis to esri shape slow

[Mario Jurcevic]

On 04/30/2014 05:32 PM, Even Rouault wrote:
> Le mercredi 30 avril 2014 17:19:04, Mario Jurcevic a écrit :
>> On 04/30/2014 05:11 PM, Even Rouault wrote:
>>> Not that much a big difference... Perhaps you should try to isolate which
>>> layer conversion if particuarly slower with ogr2ogr
>>
>> I get big difference:
>>    time ogr2ogr -sql 'select
>> "soft_gis_serial","Origine","Qualita","Genere",st_curvetoline("Geometria")
>> as Geometria from test_export."Copertura_del_suolo__SuperficieCS"'\
>>
>>   >  -f "ESRI Shapefile" out.shp PG:'host=localhost dbname=test_soft_gis
>>
>> user=test_soft_gis password=passwd'
>> Warning 6: Normalized/laundered field name: 'soft_gis_serial' to
>> 'soft_gis_s'
>>
>> real	0m2.359s
>> user	0m0.040s
>> sys	0m0.004s
>>
>> With debug on there there is many notice of ogr analyzing geom tables.
>> Maybe that is, your dump miss has not the whole db.
>
> I see ogrinfo reporting 167 layers.
>
> The listing of spatial tables should be quite fast generally (in my case it
> is). Perhaps you could try " tables=foo" (really 'foo' or another dummy
> string) at the end of the OGR connexion string. This will skip that listing.
>
> time ogr2ogr -sql 'select
> "soft_gis_serial","Origine","Qualita","Genere",st_curvetoline("Geometria") as
> Geometria from test_export."Copertura_del_suolo__SuperficieCS"' out.shp
> "pg:dbname=autotest host=127.0.0.1 port=5436 user=postgres tables=foo" -
> overwrite --debug on
> real	0m0.181s
> user	0m0.110s
> sys	0m0.020s
>
> So this saves ~ 40 ms for me.
>
>

Yes!
Without hidden listing is fast.

Thank you.