• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Query Builder: regex error when passing large array to where_in

#4
(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.
Reply


Messages In This Thread
RE: Query Builder: regex error when passing large array to where_in - by objecttothis - 02-18-2019, 03:57 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.