[gdal-dev] ArcSDE: connection times too long

[Duarte Carreira]

That never occurred to me!

Ok, so I measured 48secs sharp to get ogrinfo results, by including the featureclass name in the connection and after that too (like you pointed out).

Then got 45secs with just the name in the connection, and got all layers listed.

Don't know what to make of this...

Duarte


-----Mensagem original-----
De: Frank Warmerdam [mailto:warmerdam at pobox.com]
Enviada: terça-feira, 12 de Abril de 2011 17:32
Para: Duarte Carreira
Cc: gdal-dev at lists.osgeo.org
Assunto: Re: [gdal-dev] ArcSDE: connection times too long

On 11-04-12 12:12 PM, Duarte Carreira wrote:
> Hi Frank.
>
> I do that already: ogrinfo -so -ro SDE:server,5151,,user,pdw
> user.featureclass
>
> Notice that I separate the layer name with a blank space. Using a comma does
> not work for me (wonder if the docs are right on that??).
>
> I still wait quite a bit. This is a mid-sized db, with some 1200 feature
> classes...

Duarte,

In your case you are passing user.featureclass as the layer name to
ogrinfo telling it that you only want to report on that layer.  But
to avoid opening all layers, you should also include it in the connection
string.

eg.

ogrinfo -so -ro SDE:server,5151,,user,pdw,user.featureclass user.featureclass

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent