Bryan
Posted on • Originally published atdevlogbook.com
Querying for Data in MySQL is Slow
Trying to query the MySQL database is slow (millions of records in table)
Example query:
SELECT*FROMmy_tableWHEREcode='X87L9D82NB';Just add an index to the column that is frequently used to query for data
Query to add index:
CREATEINDEXindex_nameONtable_name(column_name);Top comments(0)
Subscribe
For further actions, you may consider blocking this person and/orreporting abuse
