We have lots of indexes. KEY and INDEX are basically synonyms in MySQL. We in fact might have too many indexes defined. This is a valid hypothesis when the index size (on disk) is too close to the DB size for a table.
El lun, 21 mar 2022 a las 14:40, Victor Grousset/tuxayo (<vic...@tuxayo.net>) escribió: > Hi :) > > Has there already been the need of additional DB indices for Koha? To > speed up some queries that doesn't use a primary or foreign key. > > From what I see in kohastructure.sql , there is no index besides the > implicit ones for keys. > > Cheers, > > -- > Victor Grousset/tuxayo > _______________________________________________ > Koha-devel mailing list > Koha-devel@lists.koha-community.org > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : https://www.koha-community.org/ > git : https://git.koha-community.org/ > bugs : https://bugs.koha-community.org/ > -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/
