02-18-2019, 03:57 AM
(02-15-2019, 11:48 AM)php_rocs Wrote: @objecttothis,
Why is your Where clause so big? Can you make it smaller?
My WHERE clause isn't large. The WHERE IN clause is large however because of the number of attribute_ids that need to have the data 'moved' from one column to the next. It can be chunked into smaller segments, but there is still a significant performance hit. This is why JOIN with UPDATE exists in SQL.
