[Koha-devel] Additional DB indices for Koha?

[Tomas Cohen Arazi]

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 (<victor at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220321/1b7c0aa3/attachment.htm>