Re: Inserting a MySQL select result not working?

[Amanda J]

I had mis-understood the BETWEEN syntax. Thought the 0 year was counted.

I had to re-calculate all of my moving averages to get 5 year values.

But very happy to say all of the tables are now updated and loaded,

The global table (956536 rows) took 19 mins 3.83 sec to return a result.

Re-running with the UPDATE 30 mins 21.125 sec. Everything else was returning a result in under 10 seconds

This was with innodb_buffer_pool_size = 11G. The sort_buffer_size = 2M.

Also now get GROUP BY - just had it back to front :).

So my very warm thanks for the patient guidance. A serious value add!