nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Better method than APPEND?

JimCousins

I am processing @ 5,000 small tables (Info tables). They are the result of an intersect and summary statistics for each element of a polygon grid.
I now wish to get all tabular information into a single table. I am using python with an iterator and Append_Management, but it is slow (about 1 hour per 1,000 tables). Is there a better way to accomplish this? All tables have the same schema, only different number of rows(1 to 12).
Regards,
Jim

Finde mehr Beiträge mit dem Tag

Accepted answers

RobertBorchert

I think your stuck with what you are going. Actually an hour to append 1000 tables does not sound bad. Processing speed is dependent on size of the tables and the number of tables associated with the append. In this case 5000 tables is certainly a slow down factor, even if they are small.

Data loader is faster because your not in an edit session. However, setting it up would be cumbersom.

I am processing @ 5,000 small tables (Info tables). They are the result of an intersect and summary statistics for each element of a polygon grid.
I now wish to get all tabular information into a single table. I am using python with an iterator and Append_Management, but it is slow (about 1 hour per 1,000 tables). Is there a better way to accomplish this? All tables have the same schema, only different number of rows(1 to 12).
Regards,
Jim

All comments

RobertBorchert

Since writing my last reply I then saw Mark Boucher answer and it reminds me of something I do.

I created a simple batch file to automatically back up the databases I work with on my computer and compress them automatically. I simply click the icon first thing every morning and it starts the programs I want every morning (email, browser, ArcGIS), compresses my active databases and backs them up to the network.

Editing on a personal computer, as Mark wrote, is significantly faster in our environment then working off a hard drive on a server somewhere

RichardTruong

Hi Robert,

I tried Data Loader for my table in ArcServer, and I received an error "Cannot load simple table". Any suggestions are greatly appreciated.

Richard

MarkBoucher

Editing over a network is slow. If you are working over a network, copy the data to your local drive, edit it faster, then copy it back. Just a thought.

JimCousins

Thanks, Robert. It is helpful to know I have not overlooked the obvious.... Again.
Best Regards,
Jim

RobertBorchert

I am processing @ 5,000 small tables (Info tables). They are the result of an intersect and summary statistics for each element of a polygon grid.
I now wish to get all tabular information into a single table. I am using python with an iterator and Append_Management, but it is slow (about 1 hour per 1,000 tables). Is there a better way to accomplish this? All tables have the same schema, only different number of rows(1 to 12).
Regards,
Jim

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.