<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 11632 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 196, Issue 16<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Additional DB indices for Koha? (Victor Grousset/tuxayo)<br> 2. Re: Additional DB indices for Koha? (Fridolin SOMERS)<br> 3. Re: Additional DB indices for Koha? (Tomas Cohen Arazi)<br> 4. Re: Additional DB indices for Koha? (Victor/tuxayo)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 21 Mar 2022 18:40:12 +0100<br>From: Victor Grousset/tuxayo <victor@tuxayo.net><br>To: koha-devel <koha-devel@lists.koha-community.org><br>Subject: [Koha-devel] Additional DB indices for Koha?<br>Message-ID: <b01d23c3-f9c5-bc03-daa1-e21f50a2fe1d@tuxayo.net><br>Content-Type: text/plain; charset=UTF-8; format=flowed<br><br>Hi :)<br><br>Has there already been the need of additional DB indices for Koha? To <br>speed up some queries that doesn't use a primary or foreign key.<br><br> From what I see in kohastructure.sql , there is no index besides the <br>implicit ones for keys.<br><br>Cheers,<br><br>-- <br>Victor Grousset/tuxayo<br><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 21 Mar 2022 12:51:15 -1000<br>From: Fridolin SOMERS <fridolin.somers@biblibre.com><br>To: koha-devel@lists.koha-community.org<br>Subject: Re: [Koha-devel] Additional DB indices for Koha?<br>Message-ID: <c857d810-de12-0d4b-31b8-59c2100b2294@biblibre.com><br>Content-Type: text/plain; charset=UTF-8; format=flowed<br><br>Hi,<br><br>There has been this on (by me) :<br>Bug 3445: add more indexes on the action_logs table<br><br>Best regards<br><br>Le 21/03/2022 à 07:40, Victor Grousset/tuxayo a écrit :<br>> Hi :)<br>> <br>> Has there already been the need of additional DB indices for Koha? To <br>> speed up some queries that doesn't use a primary or foreign key.<br>> <br>> From what I see in kohastructure.sql , there is no index besides the <br>> implicit ones for keys.<br>> <br>> Cheers,<br>> <br><br>-- <br>Fridolin SOMERS <fridolin.somers@biblibre.com><br>Software and system maintainer 🦄<br>BibLibre, France<br><br><br>------------------------------<br><br>Message: 3<br>Date: Mon, 21 Mar 2022 20:13:56 -0300<br>From: Tomas Cohen Arazi <tomascohen@gmail.com><br>To: "Victor Grousset/tuxayo" <victor@tuxayo.net><br>Cc: koha-devel <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Additional DB indices for Koha?<br>Message-ID:<br> <CABZfb=WQRzt52nnPRLVOq3-ZsbvHGLfqU2ge1tX6FobmQC0Png@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>We have lots of indexes. KEY and INDEX are basically synonyms in MySQL.<br><br>We in fact might have too many indexes defined. This is a valid hypothesis<br>when the index size (on disk) is too close to the DB size for a table.<br><br>El lun, 21 mar 2022 a las 14:40, Victor Grousset/tuxayo (<victor@tuxayo.net>)<br>escribió:<br><br>> Hi :)<br>><br>> Has there already been the need of additional DB indices for Koha? To<br>> speed up some queries that doesn't use a primary or foreign key.<br>><br>> From what I see in kohastructure.sql , there is no index besides the<br>> implicit ones for keys.<br>><br>> Cheers,<br>><br>> --<br>> Victor Grousset/tuxayo<br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> website : https://www.koha-community.org/<br>> git : https://git.koha-community.org/<br>> bugs : https://bugs.koha-community.org/<br>><br><br><br>-- <br>Tomás Cohen Arazi<br>Theke Solutions (http://theke.io)<br>✆ +54 9351 3513384<br>GPG: B2F3C15F<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220321/1b7c0aa3/attachment-0001.htm><br><br>------------------------------<br><br>Message: 4<br>Date: Tue, 22 Mar 2022 00:43:07 +0100<br>From: Victor/tuxayo <victor@tuxayo.net><br>To: koha-devel <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Additional DB indices for Koha?<br>Message-ID: <a722a0f1-e294-46cf-d9ff-5bccbd3c3969@tuxayo.net><br>Content-Type: text/plain; charset=UTF-8; format=flowed<br><br>Ah we use KEY to add indices!<br>Thanks Fridolin and Tomas.<br><br>On 22-03-22 00:13, Tomas Cohen Arazi wrote:<br>> We in fact might have too many indexes defined. This is a valid <br>> hypothesis when the index size (on disk) is too close to the DB size for <br>> a table.<br><br>That might also slow down inserts and updates or is that not significant?<br><br>Cheers,<br><br>-- <br>Victor/tuxayo<br><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 196, Issue 16<br>*******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>