[Koha-bugs] [Bug 35826] Optimize building of holds queue based on transport cost matrix

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Feb 14 16:09:00 CET 2024


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

--- Comment #14 from Kyle M Hall <kyle at bywatersolutions.com> ---
More benchmarks:
build_holds_queue.pl with 3364 holds ( no tcm )
Master: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      6.447 s ±  0.678 s    [User: 4.801 s, System: 0.196 s]
  Range (min … max):    5.674 s …  7.588 s    10 runs
Bug 35826: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      6.745 s ±  0.750 s    [User: 4.962 s, System: 0.209 s]
  Range (min … max):    6.081 s …  8.219 s    10 runs

build_holds_queue.pl with 3364 holds ( with tcm )
Master: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      6.805 s ±  0.625 s    [User: 4.977 s, System: 0.232 s]
  Range (min … max):    6.046 s …  8.098 s    10 runs
Bug 35826: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      6.931 s ±  0.746 s    [User: 5.142 s, System: 0.216 s]
  Range (min … max):    5.715 s …  7.903 s    10 runs

build_holds_queue.pl with 6614 holds ( with tcm )
Master:: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      6.991 s ±  0.545 s    [User: 5.069 s, System: 0.219 s]
  Range (min … max):    6.529 s …  7.877 s    10 runs
Bug 35826: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      7.222 s ±  0.955 s    [User: 5.341 s, System: 0.234 s]
  Range (min … max):    5.977 s …  8.636 s    10 runs

build_holds_queue.pl with 9470 holds ( with tcm )
Master: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      7.345 s ±  0.760 s    [User: 5.410 s, System: 0.261 s]
  Range (min … max):    6.227 s …  8.432 s    10 runs
Bug 35826: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      6.871 s ±  0.881 s    [User: 5.056 s, System: 0.210 s]
  Range (min … max):    5.937 s …  8.221 s    10 runs

build_holds_queue.pl with 17159 holds ( with tcm )
Master: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      6.862 s ±  0.643 s    [User: 4.869 s, System: 0.194 s]
  Range (min … max):    6.034 s …  8.365 s    10 runs
Bug 35826: ./misc/cronjobs/holds/build_holds_queue.pl
  Time (mean ± σ):      7.207 s ±  0.555 s    [User: 5.132 s, System: 0.219 s]
  Range (min … max):    6.081 s …  7.833 s    10 runs

Will run with some production data next

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


More information about the Koha-bugs mailing list