Query Builder: regex error when passing large array to where_in |
(02-15-2019, 11:52 AM)kilishan Wrote: I would chunk the data into smaller pieces. Should work fine then. Yes, it doesn't error if I put the UPDATE into the foreach loop but that means that I am doing 12,000+ hits against the database which takes longer than if the WHERE_IN array could handle a 12k long array. In the end I abandoned Query Builder for this transaction in favor of db->query() due to the limitations of not being able to do a join with an update or get an efficient solution by breaking the query into two. |
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
|