I have to update 120,000 records one by one by using below update query in while loop:
UPDATE product_table SET price=100, seller_id=12 WHERE reference=12221 AND category=2 there is a composite index on reference and category which takes around 2 hours to complete. Is there anyway to optimize my update query or any other alternate?