I am new to working with databases and am unaware of their capacity in general. To be specific, I want to know much much time would a particular mysql query take. I tried searching on the internet but nowhere was I able to find an estimate neither a way to find an estimate.
So my question is if there are 900k rows containing id (Numbers from 100 000 to 900 000) in ascending order in a table. How long would it take to search a row with a particular id?
I figured that if I ask someone who has worked with databases at this scale the estimation would be known to that person.