HOW TO

Improve draw speed for DBThemes

Last Published: April 25, 2020

Summary

Layer envelopes increase drawing speed when adding or zooming to full extent for SDE layers accessed as DBThemes. SDE 3.x does not automatically calculate a layer's envelope after loading as do later releases. An empty layer envelope forces the SDE client (ArcView 3.x in this case) to calculate the layer's envelope on the fly, increasing draw time.

Procedure



Use the following SDE Administration Command syntax to modify and/or calculate a layer's envelope.

Code:
sdelayer -o alter -l <table,column> [-E <{empty | calc | xmin,ymin,xmax,ymax}>][-i <service>][-s <server_name>][-D <database>] -u <DB_User_name> [-p <DB_User_password>]


Note:
The -E flag has three options:

Code:
empty

Sets the layer envelope to empty.

Code:
calc

Calculates the layer envelope.

Code:
xmin,ymin,xmax,ymax

Sets the envelope to the specified values.

Article ID:000005316

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic