As you can imagine, searching through those DB rows one by one will be time-consuming, even on the latest hardware. The solution is to create an INDEX (or more than one) for your data.
Source: MySQL Performance: MySQL/MariaDB Indexes | Liquid Web
Was this post helpful?
Let us know if you liked the post. That’s the only way we can improve.