Trying to query the MySQL database is slow (millions of records in table)
Example query:
<pre><code class="lang-sql">SELECT * FROM my_table WHERE code='X87L9D82NB';
</code></pre>
Just add an index to the column that is frequently used to query for data
Query to add index:
<pre><code class="lang-sql">CREATE INDEX index_name ON table_name (column_name);
</code></pre>

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

Example query:
```sql
SELECT * FROM my_table WHERE code='X87L9D82NB';
```

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

Query to add index:
```sql
CREATE INDEX index_name ON table_name (column_name);
```

Querying for Data in MySQL is Slow

A logbook of developer notes on various things related to coding and servers. From Laravel Forge, Cloudflare, PHP, to Javascript, and more!