[MNT-8809] Improve / disable Bulk fetch for Explorer users Created: 10-May-13  Updated: 11-Jun-13  Resolved: 11-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.4.6

Type: Hot Fix Request
Reporter: Antonio Soler-Asenci [X] (Inactive) Assignee: Closed Bugs
Resolution: Fixed Votes: 2
Labels: None
Remaining Estimate: 0 minutes
Time Spent: 1 week, 4 hours, 30 minutes
Original Estimate: Not Specified

Issue Links:
Cloners
is cloned by MNT-8959 CLONE - Improve / disable Bulk fetch ... Closed
Related
Bug Priority:
Category 2
Hot Fix Version: 4.1.4.6
ACT Numbers:

62698

Build Location: http://releases.alfresco.com/Enterprise%204.1/4.1.4/PATCH%204.1.4.6/build-00120/

 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:
on a big 4.1.2 environment using Oracle and few million nodes with Solr as search subsystem
open Alfresco explorer and search for "doc" or "pdf" that would give you a big resultset.
Repeat the searches with 4.1.3 and compare timings.

Aditionally:
Sample test info (from https://issues.alfresco.com/jira/browse/MNT-801?focusedCommentId=218837&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-218837 )

Warm caches, times from Firebug

v4.1.2
search for DOC 1.18s
Search for PDF 1.22s
Search for TXT 0.83s

v4.1.3
search for DOC 3.3s
Search for PDF 2.2s
Search for TXT 1.49s

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:

https://issues.alfresco.com/jira/browse/MNT-801?focusedCommentId=220987&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-220987



 Comments   
Comment by Alfresco QA Team [ 11-Jun-13 ]

Successfully validated against 4.1.4 (.6 r50564-b117) schema 5,118

 
<long name="Alfresco Nodes in Index">45581</long>
<long name="Id for last TX on server">39576</long>
<long name="Id for last TX in index">39576</long>
4.1.3 (97) schema 5,118
//Cold Cache
13.063s
//Warm Cache
0.551s
4.1.4 (.6 r50564-b117) schema 5,118
//Cold Cache
5.908s
//Warm Cache
0.437s
Generated at Tue Feb 18 17:50:17 GMT 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.