[Koha-devel] Additional DB indices for Koha?

[Fridolin SOMERS]

We add some issues with indexes on timestamp.
1 lines never have the exact same timestamp to the index is never 
efficient right ?

Best regards,

Le 23/03/2022 à 10:12, DevinimKoha a écrit :
> 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,
>>
> _______________________________________________
> 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/

-- 
Fridolin SOMERS <fridolin.somers at biblibre.com>
Software and system maintainer 🦄
BibLibre, France