topic Re: EXTREMELY SlOW JOINS in Geoprocessing Questions

EXTREMELY SlOW JOINS

KeithHenderson — Mon, 01 Dec 2014 21:01:55 GMT

I'm having a bear of a time with what should be a simple task. Joining property sales data to parcels that have been mapped. The join works fine but takes forever. Then, once the join is completed, it takes longer than forever for either the layer to draw or the attribute table to open. There are only 2,800 records in my dataset so this should not be happening. Additionally, if I try to export the data to create a new shape with the data I have joined, I get "Create output class feature failed."

Re: EXTREMELY SlOW JOINS

JakeSkinner — Mon, 01 Dec 2014 21:13:18 GMT

Hi Keith,

How is your data stored? For example, a File Geodatabase, SDE Geodatabase, Shapefile, DBF table, etc. Are you accessing any of the data over a network?

Re: EXTREMELY SlOW JOINS

KeithHenderson — Thu, 15 Jan 2015 13:30:39 GMT

Sorry to take so long on this. I sort of gave up and just waited and waited and waited until I could finish the project,

Still using shapefiles (I'm an old man). Yes, it is over a network but I did try to see if that was the issue by storing my map and data to a local drive. I also tried converting to a geodatabase and storing that on my local drive but that gave me the same error message.

Re: EXTREMELY SlOW JOINS

JakeSkinner — Thu, 15 Jan 2015 14:11:38 GMT

Would you be able to zip and upload the data you are working with? It sounds like it's data specific.

Re: EXTREMELY SlOW JOINS

JeffPace — Thu, 15 Jan 2015 14:13:13 GMT

Its doing full table scans. Make sure you build an attribute index on the fields you are joining on.

Re: EXTREMELY SlOW JOINS

KeithHenderson — Tue, 05 May 2015 16:13:54 GMT

I did switch to the geodatabase format and that helped significantly but creating the file still took forever. Probably just a problem with our miserable network.