Posted on • Originally published at devlogbook.com
Trying to query the MySQL database is slow (millions of records in table)
Example query:
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:
CREATE INDEX index_name ON table_name (column_name);
For further actions, you may consider blocking this person and/or reporting abuse
Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.
Gen -
JHK infotech -
DPC -
DPC -
Top comments (0)