[gdal-dev] ArcSDE: connection times too long

[Duarte Carreira]

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

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

On 11-04-12 10:33 AM, Duarte Carreira wrote:
> Hi listers.
>
> I'm seing a very long delay while connecting to ArcSDE. Even if I just do
> ogrinfo on a single layer I still have to wait a few minutes before I get
> anything back.
>
> Any parameter I can use?

Duarte,

The SDE driver docs at http://www.gdal.org/ogr/drv_sde.html says:

"If the layer parameter is specified then the SDE driver is able to skip
reading the summary metadata for each layer; skipping this step can be a
significant time savings."

So try listing the layer of interest in the connection string.


   SDE:server,instance,database,username,password,layer

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