[Koha-devel] Additional DB indices for Koha?

[DevinimKoha]

Hi all,

Indexes and in generally speaking database performance tuning is quite 
complex in some cases and is very related with your system, data, size 
of customers, etc.

It is better to look at every system specifically.

In general, it is not true that indexes give performance everytime. I 
may see, in many cases, indexes become a big issue in lots of databases 
after a while.

As you mentioned, in some cases insert,updates can be quite slow in some 
situations due to indexes.

On 22.03.2022 02:43, Victor/tuxayo wrote:
> Ah we use KEY to add indices!
> Thanks Fridolin and Tomas.
>
> On 22-03-22 00:13, Tomas Cohen Arazi wrote:
>> 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.
>
> That might also slow down inserts and updates or is that not significant?
>
> Cheers,
>