Comment 2 for bug 789747

Revision history for this message
Ben Shum (bshum) wrote :

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.