[3.x] Discussion • Re: cache flush ultra slow query - index optimization fix

Home of phpBB Development
Répondre
Avatar du membre
MagicFeedBot
Bot de publications
Messages : 5580
Enregistré le : 17 mai 2024, 23:49
Statut : Hors ligne

[3.x] Discussion • Re: cache flush ultra slow query - index optimization fix

Message par MagicFeedBot »

yes, I doubt this will have an adverse effect on other DBMSs. MySQL is pretty popular (as is MariaDB, which probably will behave the same, I haven't tested it). The additional index doesn't harm anything, it basically fixes a wrong (albeit a very logical) assumption that if you have an index that covers all search columns, it actually improves performance....

En savoir plus...
Répondre