topic Re: Limit Spatial Index in Data Management Questions

Limit Spatial Index

ClovesAntonio1 — Tue, 07 Jan 2014 15:49:40 GMT

Hi,

We have an application in ArcGIS 10 platform that uses spatial indexes.
The indices of this application to a particular region had its boundaries changed 9.2km to 90km.

This asks from is if we have a limit to establish the change of indices so that does not cause problems in the performance
of the database.

Cloves Antonio
CGI Brasil

Re: Limit Spatial Index

VinceAngelo — Tue, 07 Jan 2014 15:59:40 GMT

It's nearly impossible to answer a question with so few details correctly --

In what format is the data stored?

If it's a ArcSDE geodatabase, in which RDBMS?

What geometry format is in use?

How did you change the boundaries of indicies in an application?

Generally speaking, significant changes to data require systematic reconstruction
of all indexes (though sometimes they also require reloading of the table itself
to eliminate the impact of fragmentation, then reconstruction of all indexes).

- V

Re: Limit Spatial Index

ClovesAntonio1 — Tue, 07 Jan 2014 16:20:07 GMT

Vangelo,

1) If it's a ArcSDE geodatabase, in which RDBMS?
ArcSDE 10 with RDBMS Oracle 10g

2) What geometry format is in use?
Feature class

3) How did you change the boundaries of indicies in an application?
The user execute the following steps:
1) Select the area you want to move
2) Moviment 90km to the selected region.
Problem: This movement this generating a consumption of 20% of use of memory usage to only one user. The concern is when we have 100 concurrent users if the infrastructure to meet this movement.

Generally speaking, significant changes to data require systematic reconstruction of all indexes (though sometimes they also require reloading of the table itself to eliminate the impact of fragmentation, then reconstruction of all indexes).

Cloves Antonio

Re: Limit Spatial Index

VinceAngelo — Tue, 07 Jan 2014 18:21:16 GMT

The geometry storage options for Oracle are: ST_GEOMETRY, SDELOB, and SDO_GEOMETRY.

I do not understand your description. Are you saying you moved a feature to a different
location in the envelope? A change in memory usage makes no sense in this context (unless
you're using an early 10gR2, like 10.2.0.1, which isn't supported at all).

You should probably speak with your local Tech Support office.

- V

Re: Limit Spatial Index

ClovesAntonio1 — Wed, 08 Jan 2014 15:27:20 GMT

Vangelo,

I´m sorry.
Ours problem this in relation the use of memory on server of application.
When the user select one area the area this is sent to memory of server.
After, the move user this area to one new region with at 90km.
The number of data this area is very big and the memory of server not this supporting.

The question is if change of memory of server, but think than the problem continuing
OR
If we create one limit in range of grid spatial index the problem are resolved.

Version Oracle Used: 10.2.0.5 64 bits

Cloves Antonio
CGI Brasil

Re: Limit Spatial Index

VinceAngelo — Wed, 08 Jan 2014 15:51:42 GMT

I'm sorry, but still don't understand the issue. What does "one limit in range of grid spatial
index" mean?

What does 'sdelayer -o describe_long' report for the layer?

Oracle 10g is very old, and while technically supported by Oracle, it's difficult to reproduce
errors on on database no one uses any more.

- V