Ancestors

Toot

Written by Daniel Karp on 2024-10-11 at 20:15

I hate MySQL/MariaDB voodoo. I moved a JOIN from one spot in a query to further down the list, and sped up a query from 10 minutes to 0.2 seconds, but only for one user. It was already fast for most users, but for this user, it couldn’t figure out what index to use for a a separate JOIN with the previous arrangement. Total voodoo.

=> More informations about this toot | More toots from karptonite@mstdn.social

Descendants

Written by Kevin Boyd on 2024-10-11 at 21:55

@karptonite FORCE INDEX can be used to instruct the query planner to not be dumb. Very useful in high-load environments.

=> More informations about this toot | More toots from kboyd@phpc.social

Written by Daniel Karp on 2024-10-11 at 22:16

@kboyd I tried USE INDEX but not force. Maybe I’ll see if that would have worked.

=> More informations about this toot | More toots from karptonite@mstdn.social