Very slow connections to ArcSDE with over 20,000 datasets

Question

I have a problem with ArcSDE that I have never come accross before and I was wondering if anyone could shed any light on this problem.

Problem ArcSDE 9.3.1:

Connnecting to an ArcSDE instance (Oracle Spatial) with over 20,000 datasets (raster) causes ArcGIS/ArcObjects code to connect very slowly - minutes in fact before a successful connection is made to the database. However if a native SQL connection is made, the connection is almost instant.

Has anyone else had this problem and if so what can be done to remedy this problem.

Probably a better description of the connection strings and particulars of the keyword datatype would be beneficial. — Brad Nesom, Oct 18 '11 at 14:45
Not sure until I get to the client site - but I'm guessing they are just plain loaded into ArcSDE without any configuration. — Vidar, Oct 18 '11 at 14:58
I will get back to you with more details when I get to the client site too...maybe I was jumping the gun a bit too much here :) — Vidar, Oct 18 '11 at 15:17
Actually, I remember, they are loaded into the database as blobs - so each tile is a blob, I don't think they use raster catalogs at all. — Vidar, Oct 18 '11 at 15:27

score 4 · Accepted Answer · answered Oct 18 '11 at 17:27

4

Are they registered with the GeoDatabase and in A Raster Catalog? If not, it basically has to dynamically find info about each table and 20,000 DB DESCRIBEs can get kind of heavy and time consuming :)

answered Oct 18 '11 at 17:27

Ragi Yaser Burhum

15,339
2
59
76

ahh interesting. This has given me some things to think about - hopefully it should be a fairly easy fix. – Vidar Oct 18 '11 at 19:50

score 0 · Answer 2 · answered Oct 19 '11 at 13:15

0

We had a noticeable speed improvement when we switched our users over to Direct Connections.

answered Oct 19 '11 at 13:15

Casey

2,040
1
16
23

Very slow connections to ArcSDE with over 20,000 datasets

2 Answers2