Showing results for 
Search instead for 
Do you mean 

Improving Attribute Performance for the G/Tech Data server

by Technical Evangelist on ‎03-01-2016 08:27 AM - edited on ‎04-07-2016 06:04 AM by Moderator (394 Views)

Question

How users can improve attribute query performance over a feature class by defining a flattened view for that feature class.

Answer

If the G/Technology data server internally identifies that there is a flattened view defined for a feature class, attribute queries are run over Oracle first using a live ADO connection, and the data server internally gets several key fields (G3E_ID, G3E_FID, and G3E_CID) information along with additional fields defined over that flattened view. Using the data of these key fields, the data server internally picks up graphics information from the DDC file and serves the final filtered data to the client.

However, you must organize the query statement in such a way that minimal records are fetched from the Oracle warehouse over the network; otherwise, it may also degrade the performance.

Contributors