Hi again,
The performance of search (including term completion search) has been radically improved by making changes to app and services config to reduce fan out. UCB would like to contribute this back to core as part of the v2.3 release, and in fact the changes have already been contributed into the repository by Patrick Schmitz.
A Jira ticket for this contribution is
http://issues.collectionspace.org/browse/CODE-1
and a wiki page has been made at
http://wiki.collectionspace.org/display/collectionspace/Improved+search+performance+by+reducing+fan+out
Here are some stats on the improvements:
Request Type Time Before (s) Time After (s) x Speedup
media search (50 records) 41.52 1.47 28.2
catalog search (50 records) 17.91 2.78 6.4
taxon search (50 records) 33.51 5.01 6.7
taxon autocomplete (*) 37.27 2.44 15.3
Let me know if you have any questions about these changes.
Thanks,
Chris
Hi again,
The performance of search (including term completion search) has been radically improved by making changes to app and services config to reduce fan out. UCB would like to contribute this back to core as part of the v2.3 release, and in fact the changes have already been contributed into the repository by Patrick Schmitz.
A Jira ticket for this contribution is
http://issues.collectionspace.org/browse/CODE-1
and a wiki page has been made at
http://wiki.collectionspace.org/display/collectionspace/Improved+search+performance+by+reducing+fan+out
Here are some stats on the improvements:
Request Type Time Before (s) Time After (s) x Speedup
media search (50 records) 41.52 1.47 28.2
catalog search (50 records) 17.91 2.78 6.4
taxon search (50 records) 33.51 5.01 6.7
taxon autocomplete (*) 37.27 2.44 15.3
Let me know if you have any questions about these changes.
Thanks,
Chris