How to implement fast data update in mysql?

Question

MySQL

There is a database of disposable goods, for the test I loaded about a million units of goods there. And here UPDATE in this table lasts 3 seconds. The first SELECT after an UPDATE also lasts 3 seconds (then cached until the next UPDATE).
I rarely use SELECT, but I have to use UPDATE often, so the question is, how are databases optimized? I don't think that a million lines is a lot, but I'm sure that all this should obviously not work for 3 seconds. What data do you need to provide or do you have any general advice on compiling a database?

UPDATE and SELECT

SELECT only (cached)

timer - request execution time

Answer 1

Databases are optimized by creating the right indexes and building queries that use those indexes.

Answer 2

You can delete the index before updating the data, then recreate it.