[Koha-bugs] [Bug 27880] Store each database migrations state in database

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27880

--- Comment #17 from Julian Maurice <julian.maurice at biblibre.com> ---
(In reply to Julian Maurice from comment #14)
> It would be interesting to see how much time it takes to process a directory
> of 100, 1000 and 10000 entries (we are getting close to 1500 updates
> actually in master)

Just ran a quick test:

Time to execute pending_migrations with an empty executed_migrations table and:
- 100 migration files: <1ms
- 1000 migration files: ~1.2ms
- 10000 migration files: ~6ms

Time to execute pending_migrations with a full executed_migrations table and:
- 1000 migration files: ~1.6ms
- 10000 migration files: ~12ms

Note that I got these times with two small modifications I made to
pending_migrations, which I will submit with the rebased patch, they save a few
ms in the "10000 files" test.

One way to avoid slowdowns as the number of files grows is to check for pending
migrations only once at the start of the application, and not at every request.

-- 
You are receiving this mail because:
You are watching all bug changes.