Comment 5 for bug 1827250

Revision history for this message
Jason Stephenson (jstephenson) wrote :

Thanks for the suggestion, Mike. I tried both variants with explain analyze, and the nulls last version is overall faster. (See the attached document with the results for a single copy.)

I made a new branch using nulls last on the order by and posted it to the working repo. It still resolves the issue for our example holds shelf where there are multiple copies missing. Since it about 1 ms faster than the is not null version, we should use this one:

https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/dyrcona/lp1827250_last_captured_hold_fix_nulls_last