arcgis-desktoparcmapperformance
Is there a way to speed up rendering data into ArcMap ?
When I converted the raster to polygon and some data would render quicker and some other renders slow.
I am wondering if I could add the spatial index to the data that renders slow.
Would that work or is there anything that I could make the data render quicker?
This answer is a working progress.
I aim to do some of my own benchmarks with some Esri sample datasets and also gather stats from external sources.
From the GISWorx link:
From the Esri UK link: (Although this relates to the optimisers pointing out potential problems with choices in authoring stage e.g. use of maplex)
The most efficient index for the query expressed in your question is the one on gid as it is the only column that appears in a where expression:
CREATE INDEX table_gid ON table (gid);
You can safely drop the gist index as it will only consume space and slow inserts/updates/deletes down.
As I said the most effective index in your case is the one on gid as it will allow the db engine to retrieve rows faster (with retrieval usually being the slowest part of the process). After that it will probably better compute the result of the
ST_Contains(a.way, b.way)
espression without looking at the index. The reason is that the query planner will likely estimate that the extra cost of looking up the gist index on both columns versus looking up the a.way and b.way values directly is not worth the effort as the total number of rows to look up is probably very small especially if the index is unique.
As a rule of thumb remember that the planner will probably favor a table scan over an index scan for small datasets (dataset sizes are estimated by looking at the table statistics).
Best Answer
It is all about throughput.
and for Caching
Also if you are a single machine (no network), no enterprise considerations, you should take a read here Derek Law has some good advice on some whitepapers.