DEV Community

Bryan
Bryan

Posted on • Originally published at devlogbook.com

Querying for Data in MySQL is Slow

#mysql #indexing

Trying to query the MySQL database is slow (millions of records in table)

Example query:

SELECT * FROM my_table WHERE code='X87L9D82NB';
Enter fullscreen mode Exit fullscreen mode

Just add an index to the column that is frequently used to query for data

Query to add index:

CREATE INDEX index_name ON table_name (column_name);
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

truongpx396 profile image

⚡ 🚀 Quickly Start Dev Environment For MySQL, PostgreSQL, MongoDB, Redis, and Kafka Using Docker Compose 🔥

Truong Phung -

khold profile image

Inside the Database: A Deep Dive into Disk-Oriented DBMS.

Ahmed Khaled -

manojspace profile image

Adding a Serial ID to MySQL Tables Based on Creation Date: A Step-by-Step Guide

Manoj Swami -

truongpx396 profile image

🛠️ DB Migration For Golang Services, Why it matters? 🐹

Truong Phung -