MYSQL >> Index , and .5 sec updates in 4k record table

Issue

I got a table that gets updated every half a sec. Multiple columns. The table has 4k rows.
Is it wise to creat indexs and use them when I select ?

Thank you

Solution

Short answer: Yes.

Not so short answer: Definitely.

Long answer: Show us the queries (SELECT/UPDATE/DELETE) that you use on that table. We can make the answer even longer.

But. Do not simply "index every column". We will at each query and find the optimal index for it.

Answered By – Rick James

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published