idea Speed up table sorting, as benchmarked by ArcCatalog in ArcGIS Pro Ideas

Speed up table sorting, as benchmarked by ArcCatalog

wayfaringrob — Tue, 27 Jun 2023 16:16:34 GMT

Speed up the sorting of a table by an attribute (via double click on header, for example). I have a large table that is done sorting in a matter of seconds. In Pro, the same dataset takes nearly a minute.

Re: Speed up table sorting, as benchmarked by ArcCatalog

KoryKramer — Wed, 21 Jun 2023 19:18:55 GMT

Unfortunately I don't think that this performance issue will be actionable as an idea because it won't be generically applicable to all Pro users and likely depends on a number of various factors.

Working with a local file geodatabase table of 3,036,300 records, sorting in Pro takes around 5ish seconds. Here is the gif, no speeding up during processing:

Sorting the same table, same data location, in ArcCatalog takes 1 minute 41 seconds while Catalog shows (Not Responding). You can't see the spinner in the .gif, but if you wait for 1:41 you'll see the table sort.

This one falls into #4 of the pre-submission considerations for ideas: https://community.esri.com/t5/community-help-documents/arcgis-ideas-submission-guidelines-and-statuses/ta-p/904874#toc-hId--707044681

Re: Speed up table sorting, as benchmarked by ArcCatalog

Bud — Fri, 07 Jul 2023 19:14:18 GMT

Somewhat related:
Perform join at the database level, not the application level, when the datasets are in the same workspace
(Involves performance issues when sorting on a joined field.)