[Koha-devel] Faster database update checks

[David Cook]

Hi all,

 

I just wanted to bring people's attention to my bug "Bug 34088 - Schema
upgrade should short circuit faster if no upgrade needs to be done".

 

It can check if Koha needs a database update in a fraction of the time of
the current code. When you have a lot of Koha databases, processing database
updates (especially when there is no update to do!) takes a long time. But
you can check 60 databases in about 3.5 seconds with my patch (instead of
over 60 seconds).

 

This should speed up deployments.

 

--

 

On a side note, I think that having #DEBHELPER# *before* koha-upgrade-schema
means that Koha is started up *before* the database is upgraded. I'd have to
double-check that, but it could lead to buggy behaviour.

 

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20230704/470cae46/attachment.htm>