Server load at type IN( request)



  • That's the question, if I make a sql request like, WHERE id IN(12,3,54,5,6,8,234) And so on, will this not cause, for example, the fall of the server if the number of those most IN You're gonna grow up to, like, 10,000 identifiers?



  • MS Sql Server leaves an exception if the request has more than 2,100 parameters. MySql may have such restrictions, too. If I have to make a sample that has more than 2,100 values in IN, I group the set of values and make a few requests.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2