I have a table (mysql) that has 150k rows. During the day there are multiple updates (1000s) that change an int value to another int value (update table set field = ? where table.id = ?). nothing complicated in the UPDATE query.
Would moving to something like Mongo db be faster? The database gets 100s (1000s?) more reads (selects) than these writes. What are my options?