Query Builder: regex error when passing large array to where_in |
(02-15-2019, 11:48 AM)php_rocs Wrote: @objecttothis, 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. |
Messages In This Thread |
Query Builder: regex error when passing large array to where_in - by objecttothis - 02-15-2019, 01:31 AM
RE: Query Builder: regex error when passing large array to where_in - by php_rocs - 02-15-2019, 11:48 AM
RE: Query Builder: regex error when passing large array to where_in - by objecttothis - 02-18-2019, 03:57 AM
RE: Query Builder: regex error when passing large array to where_in - by kilishan - 02-15-2019, 11:52 AM
RE: Query Builder: regex error when passing large array to where_in - by objecttothis - 02-18-2019, 04:01 AM
RE: Query Builder: regex error when passing large array to where_in - by kilishan - 02-18-2019, 07:07 AM
|