Welcome Guest, Not a member yet? Register   Sign In
preg_match(): Compilation failed: regular expression is too large
#11

(09-24-2015, 08:00 AM)Narf Wrote:
(09-24-2015, 07:29 AM)blasto333 Wrote: I was able to write my own method and use simple_query...Is this the right method to use for RAW queries without regex issue?


(09-23-2015, 06:57 PM)blasto333 Wrote: has anyone created a helper method to update 5 columns in a table with a very large where_in array? I am going to write a method for this; but if someone already has a similar method I would love to use that.

It's not a wrong one, but unless this "large where_in array" is user input (and that just sounds unlikely), I'd still question why do you have to pass it from PHP to the database. Because, if my assumption is correct, the values in that array are actally fetched from that same database, which means you could do UPDATE x = y WHERE z IN(subquery).

In my case it is 'special' CLI works (that happens only once) on thousands of entries, and the process is divided by several call of a function for a limited n entries for performance issues, i didn't create a database column just for this and store the ids in a file each time one entry is processed... so each time i call the function the where_not_in is a big array from that file.
perhaps i should have create a column just for this .?.?. well excuse my english i hope you understood me
Reply




Theme © iAndrew 2016 - Forum software by © MyBB