Extremely Slow Exporting a Joined Feature Class in Geodatabase

Question

Dear all,

I was trying to join a table (containing some useful attribute) to a feature (9m polygons) in Geodatabase.

The table has an ID that is matchable with an ID of the polygons.

The join was fast. But when I try to export the joined feature to either a shapefile or a table, it is extremely slow.

I wonder why is that exporting so slow and is there a better way to permanantly join the attribute contained in the table into the feature (9m polygons)???

Thanks so much.

CarolynScholl3 · Answer

I also ran into this issue when joining updata CVAP data to over 500,000 census blocks. I need all of the census blocks so I can't be selective about which ones to export. It is going on 18 hours and it is 97% complete. Did you ever find a solution? The only thing I'm thinking is exporting small portions at a time and then stitching them together?

BirajaNayak · Answer

Can you give us the detail requirement like what is the purpose  of join and what are information you are looking on a join table. Do you really need all 9m feature to be joined with all attributes or few of the feature which are required can be extracted to a new feature class and join.

If you are not editing the joined data, only used for view and query then how about spatial view or database view created from joined table and feature class.

YulunZhou · Answer

Hi Sephe,

Thank you for answering.

I already tried the GDB file and the join field tool. I think what you said makes sense, as the join field tool should reduce the amount of information to be processed. But the result is that it is still extremely slow. (Maybe faster than the exporting way, I never waited that long)

The overall purpose is to permanantly join the attributes to the feature, any good way of realizing it?

Yulun