Calculate Field Extremely slow when done for SQL based layer

nacelle_pylon

Is there a preferred way to calculate a field?

I calculated two fields separately in a table in SQL via the Geoprocessing Tool ‘Calculate Field.’

Seems ridiculous to me with the processing power available that it takes 45 minutes to calculate 45K rows of 1 field with a simple conversion from a double datatype to text.

I would understand if I were calculating Einstein’s Theory of relativity on every cell.

I performed the exact same calculate with the same feature layer and data but in a File Level GDB on a file server residing 20 miles away.

It took 11 seconds!!

If my math is correct, that’s 24,545% faster.

The only thing removed from the equation was SQL. What gives? Any help or suggestions?

RandyMcGregor_BMcD

Calculating values in hosted feature layers is excruciatingly slow. Dozens of seconds - often minutes - to do calculations that are not complex on small numbers of rows (max 1000)