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@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.som...@biblibre.com>
Software and system maintainer 🦄
BibLibre, France
_______________________________________________
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/