English

How To: Improve draw speed for DBThemes

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.