Welcome Guest, Not a member yet? Register   Sign In
Bug with large IN query
#6

(This post was last modified: 07-26-2018, 01:36 AM by michaelv.)

dear all thanks for your reply
i just follow the "bug" i found
this code was for previously viewd items on an ecommerce website
we never excpected a user to see more than 1000 produtcs in a session
but botnet do
i'll manage to recode this stuff or simply limit the previously view items to 100 or so

question, in term on performence, what would be better ?
100 lines like this:
$this->db->or_where_in('id_prod', $chunk);
or 100 Ids in a IN clause ?
Reply


Messages In This Thread
Bug with large IN query - by michaelv - 07-25-2018, 07:08 AM
RE: Bug with large IN query - by php_rocs - 07-25-2018, 08:10 AM
RE: Bug with large IN query - by michaelv - 07-25-2018, 08:43 AM
RE: Bug with large IN query - by dave friend - 07-25-2018, 09:15 AM
RE: Bug with large IN query - by zurtri - 07-25-2018, 04:14 PM
RE: Bug with large IN query - by michaelv - 07-26-2018, 01:18 AM
RE: Bug with large IN query - by php_rocs - 07-26-2018, 08:56 AM



Theme © iAndrew 2016 - Forum software by © MyBB