[MNT-8959] CLONE - Improve / disable Bulk fetch for Explorer users Created: 04-Jun-13 Updated: 10-Jul-13 Resolved: 13-Jun-13 |
|
Status: | Closed |
Project: | Service Packs and Hot Fixes |
Component/s: | Alfresco Explorer, Search and Indexing (non-UI) |
Affects Version/s: | 4.1.3 |
Fix Version/s: | 4.1.5 |
Type: | Bug | ||
Reporter: | Antonio Soler-Asenci [X] (Inactive) | Assignee: | Closed Bugs (Inactive) |
Resolution: | Fixed | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Issue Links: |
|
||||||||
Bug Priority: |
|
||||||||
Build Location: | http://releases.alfresco.com/Enterprise%204.1/4.1.5/build-00080/ |
Description |
On MNT-801 we discovered that the search service now implements a feature to "bulk fetch" node properties when searching for them. For a customer with Oracle, this has caused the search time to increase linearly with the size of the resultset, meaning that searches on 4.1.3 are slower than on 4.1.2 In tests and profiling attached on MNT-801 we observed that most of this time was spent doing DB queries. The customer is requesting that there is either a way to disable the bulk-fetching, or improve it so that there is no speed degradation fro Explorer users. To reproduce the problem: Aditionally: Warm caches, times from Firebug v4.1.2 v4.1.3 These timings are for tests on Support's systems. The tests on the customers systems show a similar percentage change, but all times are longer, so the impact is much greater. 4.1.4 shows a small, almost negligible improvement. Andy Hind proposed a rethink/reimplementation of the bulk fetch: |
Comments |
Comment by Alfresco QA Team (Inactive) [ 13-Jun-13 ] |
Validated against 4.1.5 (r50971-b24) schema 5,120 <long name="Id for last TX on server">39580</long> <long name="Alfresco Nodes in Index">45585</long> 4.1.3 (97) schema 5,118 //Cold Cache 13.063s //Warm Cache 0.551s 4.1.5 (r50971-b24) schema 5,120 //Cold Cache 4.288s //Warm Cache 0.481s |