💾 Archived View for whitemercury.ddns.net › mysql-index-improvement.gmi captured on 2022-04-28 at 17:35:10. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2021-12-03)
-=-=-=-=-=-=-
I’m very pleased with myself today. I actually bothered to track down what was slowing down my website.
I’d first like to say I prefer the word indices to indexes. Also it’s My-S-Q-L not My-Sequel. Actually it’s MariaDB, but that’s not the point.
There were 2 parts of the website that worked painfully slow and I assumed it was something to do with Twitter, but when I actually bothered to check it was that the database wasn’t using the right index. I looked up how to force/suggest the correct index and the query went from taking 2-5 seconds to taking under a tenth of a second!
Excellent result as I pictured having to rewrite several big chunks of code! This took much less time and effort!
--------------------------------------------------------------------------------
This file is located at URL:
gemini://whitemercury.ddns.net/mysql-index-improvement.gmi