The recent dataset I'm working with is a huge array of 12 million hexagonal polygons, essentially acting as variable bins for 70 variables of all sorts of types. I generally run processing with it on a Windows 10 i7-7700 machine, yet find even loading the attribute table to take several minutes. Even when I created a 250K slice of the hexes, it still takes a long slog to view the table.
I do have a join, basically linking the hexagonal polygon feature class (has only 5 variables) with an aspatial .csv file containing the other 65 variables. I keep wondering if exporting into a new feature class - thus having a complete & unjoined polygon feature class - would see gains in browsing and processing efficiency.
Thoughts?