Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySQL questions regarding WHERE id IN
07-19-2018, 02:37 PM,
Post: #1
MySQL questions regarding WHERE id IN
Hello,

I've got a table with about 1200 records in it (but growing by about 20-30 records per week) where each record is about 1kb in size. I need to pull a subset of records from the table based on a list of ids deemed 'active'. This list will amount to about 98% of the records. Are there performance implications to having a query of the type 'SELECT * FROM table WHERE id in (1,2,3.....)' where the IN clause has well over 1000 numbers in it? Would I be better off pulling every record and culling them in PHP? I'm assuming I'm better off doing it in MySQL, but I wanted to make sure I won't be killing MySQL by having such a large IN list.

Any help will be apprecited.

I didn't find the right solution from the Internet.

References:
https://arstechnica.com/civis/viewtopic....&t=1150284
Motion graphics video animation agency

Thank you.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)