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.