[Geomedia-l] very slow GM response using ORCL database

[Jeff_Hobbs at sjwater.com]

Csongor,
 
The data in Oracle are spatially indexed (accurately) and have the correct
MDSYS metadata setup, correct?
 
I still wouldn't think it would take 10 minutes to load 20,000 areas, but
it would definitely take a lot longer.
 
Jeff
 
 
 
--------------------------------
Jeff Hobbs
GIS Coordinator
San Jose Water Company (NYSE:SJW)
1265 South Bascom Avenue
San Jose, CA 95128
Voice - (408) 279-7833
Fax - (408) 279-7889
jeff_hobbs at sjwater.com
http://www.sjwater.com <http://www.sjwater.com/> 
 

  _____  

From: geomedia-l-bounces at directionsmedia.net
[mailto:geomedia-l-bounces at directionsmedia.net] On Behalf Of
Kubany.Csongor at topomap.hu
Sent: Thursday, June 07, 2007 01:00
To: geomedia-l at directionsmedia.net
Subject: [Geomedia-l] very slow GM response using ORCL database



Hi all,

 

Our partner ecountered the following problem:

 

They have some geological data (less than 20000 area feature with and
w/out holes) in Access database.

 

They put a lot of attribute info into it, and migrate it to ORCL.

 

In Access, everything is worked properly, but after the migration to ORCL,
even displaying the data takes more than 10 minutes.

 

They are using GMPro 6.0 and ORCL 10.

 

Anybody has some similar experience or knows where to start to solve this?

 

Thanks in advance

 

Csongor

 

Csongor Kubany

Deputy Chief

Dept. of Cartography

MoD Mapping Company

kubany.csongor at topomap.hu

kubany.csongor at chello.hu

+36205551820

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.directionsmedia.net/pipermail/geomedia-l/attachments/20070607/7525e08e/attachment.html