Hello everyone,
I just found this great website and registered here to ask some questions. I need to optimize some mysql queries, because they are slow now.
Actually, my table structure is simple - there is "id" column (primary), "keyword" column (index) and some other columns. All my queries look like select * from table where keyword='xxx'
There are about 20.000 records in table, and I'm using index length of 30 for "keyword" column, but it's still slow. Usually records in "keyword" column are about 50-60 characters length, so I'm not sure if index lenght of 30 characters is good, or should I increase (decrease) it for better performance?
Thanks!
I just found this great website and registered here to ask some questions. I need to optimize some mysql queries, because they are slow now.
Actually, my table structure is simple - there is "id" column (primary), "keyword" column (index) and some other columns. All my queries look like select * from table where keyword='xxx'
There are about 20.000 records in table, and I'm using index length of 30 for "keyword" column, but it's still slow. Usually records in "keyword" column are about 50-60 characters length, so I'm not sure if index lenght of 30 characters is good, or should I increase (decrease) it for better performance?
Thanks!
Comment