We're also using Evergreen 2.0.6, OpenSRF 2.0.0, but with PostgreSQL 8.4.
Tested replacing with unnest() in the search function for status and location. Subsequently, we saw advanced search using "limit to available" go from 13 seconds to 1 second (for a single record result) and limiting a single copy location actually returned results instead of timing out. These are very significant improvements!
Will test the other parts of the new branch as soon as possible.
We're also using Evergreen 2.0.6, OpenSRF 2.0.0, but with PostgreSQL 8.4.
Tested replacing with unnest() in the search function for status and location. Subsequently, we saw advanced search using "limit to available" go from 13 seconds to 1 second (for a single record result) and limiting a single copy location actually returned results instead of timing out. These are very significant improvements!
Will test the other parts of the new branch as soon as possible.