A new request with request id 11667 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is :

Title : Koha-devel Digest, Vol 196, Issue 18
Category :
Description :
Send Koha-devel mailing list submissions to
    koha-devel@lists.koha-community.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
    koha-devel-request@lists.koha-community.org

You can reach the person managing the list at
    koha-devel-owner@lists.koha-community.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."


Today's Topics:

1. Re: Additional DB indices for Koha? (DevinimKoha)
2. Re: Additional DB indices for Koha? (Fridolin SOMERS)
3. Release maintenance: Monthly string freeze: shall it be
announced also on koha-devel and the general list?
(Victor Grousset/tuxayo)
4. Re: Additional DB indices for Koha? (dcook@prosentient.com.au)
5. The vendor does not exist at serials/subscription-add.pl
(Londhe Amar)


----------------------------------------------------------------------

Message: 1
Date: Wed, 23 Mar 2022 23:12:52 +0300
From: DevinimKoha <kohadevinim@devinim.com.tr>
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] Additional DB indices for Koha?
Message-ID: <89b6c5af-8ce3-ec03-363d-cab8db89660c@devinim.com.tr>
Content-Type: text/plain; charset=utf-8; format=flowed

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,
>


------------------------------

Message: 2
Date: Wed, 23 Mar 2022 10:16:54 -1000
From: Fridolin SOMERS <fridolin.somers@biblibre.com>
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] Additional DB indices for Koha?
Message-ID: <d1203054-2052-4496-9e04-619268088c53@biblibre.com>
Content-Type: text/plain; charset=UTF-8; format=flowed

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


------------------------------

Message: 3
Date: Wed, 23 Mar 2022 23:47:22 +0100
From: Victor Grousset/tuxayo <victor@tuxayo.net>
To: koha-devel <koha-devel@lists.koha-community.org>
Subject: [Koha-devel] Release maintenance: Monthly string freeze:
    shall it be announced also on koha-devel and the general list?
Message-ID: <a9078590-293a-ed7d-d1f7-fa2c96638cfb@tuxayo.net>
Content-Type: text/plain; charset=UTF-8; format=flowed

Hi :)

The idea is to push the librarians, admins, and devs to check the
translations out if they remember something off. To try to reach out
instead of relying on those already interested in translation and
subscribed to koha-translate.

Currently not all release maintainers announce the string freeze in the
same place resulting in confusion.

Cheers,

--
Victor Grousset/tuxayo


------------------------------

Message: 4
Date: Thu, 24 Mar 2022 10:32:39 +1100
From: <dcook@prosentient.com.au>
To: "'Fridolin SOMERS'" <fridolin.somers@biblibre.com>,
    <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Additional DB indices for Koha?
Message-ID: <081d01d83f0e$54151730$fc3f4590$@prosentient.com.au>
Content-Type: text/plain;    charset="utf-8"

Actually, having an index on a timestamp column can make searching much more efficient, because the indexed data is stored in sorted order by timestamp. That makes it quicker and easier to use a WHERE clause like "WHERE timestamp > date1". It can just do a binary search which is very efficient. Otherwise, the database needs to brute force the search by looping through every row, sorting the whole dataset by the timestamp, and then checking the condition. When you get into millions of rows and/or gigabytes of timestamped data, you really really want an index on that column. (Note: PostgreSQL is much better than MySQL for demonstrating this using the "EXPLAIN" and "ANALYZE" keywords, although it looks like MariaDB supports "ANALYZE" since 10.1.0 for evaluating queries using the same output format as "EXPLAIN").

In general, if the table has a small amount of data, there's no advantage adding an index (unless it's something like a UNIQUE index). If the table is large or likely to grow, it can be useful to add an index to fields that will be used for searching:
- Tables like action_logs, old_issues, old_reserves, statistics, accountlines, linktracker log transactional data forever, so they're good to index as they'll grow over time and querying those tables will become more burdensome over time. Tables like items and biblio* probably make sense, because they could potentially be large.
- A small table like "letter", it probably doesn't need any additional indexes besides ones for foreign keys and unique indexes. (Funny that I randomly chose this table since Jonathan and Martin have recently updated the DB structure for this table along those lines.)

Of course, even with indexes, sometimes a query can request too much data, and it'll cause performance problems. The "Reports" module is dangerous like that actually. But that's a whole other thing...

Btw, if you want to see what indexes are defined for a MySQL table, you can just use "SHOW INDEXES from tablename".

In MySQL, you can also use non-standard "index hints": ( E.g. ANALYZE SELECT * FROM biblio FORCE INDEX (blbnoidx) WHERE biblionumber > 1; ). Generally this isn't necessary, but I have used it from time to time for specific MySQL SQL reports.

Anyway, that's my little rant on indexes 😅.

David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia

Office: 02 9212 0899
Online: 02 8005 0595

-----Original Message-----
From: Koha-devel <koha-devel-bounces@lists.koha-community.org> On Behalf Of Fridolin SOMERS
Sent: Thursday, 24 March 2022 7:17 AM
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] Additional DB indices for Koha?

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.somers@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/



------------------------------

Message: 5
Date: Thu, 24 Mar 2022 01:59:14 -0600
From: Londhe Amar <amar@ourlib.in>
To: koha-devel@lists.koha-community.org
Subject: [Koha-devel] The vendor does not exist at
    serials/subscription-add.pl
Message-ID: <3f2551e56ef45232e10d91cccf9d9724@ourlib.in>
Content-Type: text/plain; charset="utf-8"; Format="flowed"



Home › Serials › New subscription
Unable to add new subscription in koha.

vendor is available in koha,
I am able to search for a vendor on the subscription edit form at
serials/subscription-add.pl, but when i select vendor and biblio and
click on next button it shows " The vendor does not exist " alert.

I have upgraded koha version 19.11 to 20.11.06.


Is there anything else I might want to examine that could be causing the
problem?


--
Thanks and Regards,
Londhe Amar
Software developer
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2022-03-24 13-25-56.png
Type: image/png
Size: 111479 bytes
Desc: not available
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220324/4853da5a/attachment.png>

------------------------------

Subject: Digest Footer

_______________________________________________
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/


------------------------------

End of Koha-devel Digest, Vol 196, Issue 18
*******************************************


NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.