]> git.evergreen-ils.org Git - working/Evergreen.git/commit
projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9560b33) | patch
LP1768022: Speed up ahopl user/jboyer/lp1768022_ahopl_speedup
authorJason Boyer <jboyer@library.in.gov>
Tue, 5 Jun 2018 17:57:35 +0000 (13:57 -0400)
committerJason Boyer <jboyer@library.in.gov>
Tue, 5 Jun 2018 17:57:35 +0000 (13:57 -0400)
commit0a803374cd554b3624a4cddfdbfc661bde914def
treed00d68c30a6414c8b089a60fcdbdba9f6586f4b1tree
parent9560b33ec003fd041e761e3377b740ec4a11313ecommit | diff
LP1768022: Speed up ahopl

In some cases the ahr.usr=ausp.usr join was causing
planning times to be many times the actual execution
times for this query. Changing to au.id=ausp.usr
has the same effect but vastly faster planning times.

Signed-off-by: Jason Boyer <jboyer@library.in.gov>
Open-ILS/examples/fm_IDL.xml diff | blob | history
Evergreen ILS