Does using metadata hurt the performance of a document library

%3CLINGO-SUB%20id%3D%22lingo-sub-482986%22%20slang%3D%22en-US%22%3EDoes%20using%20metadata%20hurt%20the%20performance%20of%20a%20document%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482986%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20an%20effort%20to%20improve%20search-ability%20of%20documents%2C%20I%20have%20created%20a%20metadata%20driven%20document%20library.%26nbsp%3B%20The%20files%20were%20originally%20in%20a%20library%20organized%20by%20folders.%26nbsp%3B%20The%20library%20contains%20just%20under%20300%20files.%26nbsp%3B%20We%20are%20using%202%20managed%20metadata%20fields%2C%20each%20with%20under%20200%20choices%20in%20the%20term%20store.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20original%20library%2C%20the%20library%20screen%20load%20time%20was%20just%20under%202%20seconds.%26nbsp%3B%20However%2C%20in%20the%20new%20library%2C%20the%20load%20time%20is%20more%20like%207-9%20seconds.%26nbsp%3B%20It%20also%20takes%20longer%20to%20load%20more%20documents%20in%20the%20view%20as%20you%20scroll%20thru%20the%20documents.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20ran%20other%20tests%2C%20such%20as%20removing%20the%20metadata%20columns%20from%20the%20view%20-%20helped%20a%20little%20and%20switching%20the%20library%20to%20classic%20mode%20-%20not%20much%20of%20a%20difference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20certainly%20see%20value%20in%20using%20metadata%20in%20a%20document%20library.%26nbsp%3B%20However%2C%20if%20it%20is%20going%20to%20hurt%20library%20performance%2C%20then%20it%20may%20not%20be%20worth%20the%20effort.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20experienced%20this%20issue%3F%26nbsp%3B%20Were%20you%20able%20to%20solve%20the%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-482986%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-483260%22%20slang%3D%22en-US%22%3ERe%3A%20Does%20using%20metadata%20hurt%20the%20performance%20of%20a%20document%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-483260%22%20slang%3D%22en-US%22%3EIf%20you%20jump%20in%20with%20managed%20metadata%20you%20will%20hit%20some%20performance%20degradation%20but%20it%20also%20depends%20on%20what%20type%20of%20fields%20you%20use%20as%20well.%20You%20might%20also%20go%20into%20the%20list%2C%20and%20check%20indexed%20columns%20and%20see%20about%20adding%20in%20the%20managed%20metadata%20fields.%20Pretty%20sure%20you%20can%20index%20those%20as%20well%2C%20this%20might%20help%20improve%20your%20performance.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-485643%22%20slang%3D%22en-US%22%3ERe%3A%20Does%20using%20metadata%20hurt%20the%20performance%20of%20a%20document%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-485643%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%20giving%20this%20a%20try.%26nbsp%3B%20I'll%20report%20back%20on%20the%20findings.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-499122%22%20slang%3D%22en-US%22%3ERe%3A%20Does%20using%20metadata%20hurt%20the%20performance%20of%20a%20document%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-499122%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20suggestion%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E.%26nbsp%3B%20I%20created%202%20indexes%20for%20the%20library.%26nbsp%3B%20One%20that%20indexes%20both%20columns%20(primary%20%26amp%3B%20secondary)%20based%20on%20usage%20suggestions%20from%20the%20business%20owner.%26nbsp%3B%20The%20second%20with%20just%20the%20column%20I%20designated%20as%20secondary%20in%20the%20first%20index.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20first%2C%20my%20timings%20looked%20encouraging.%26nbsp%3B%20However%2C%20the%20trends%20show%20no%20real%20changes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20mean%20that%2C%20if%20I%20use%20metadata%2C%20I%20am%20going%20to%20see%20degraded%20performance%3F%26nbsp%3B%20Load%20times%20that%20go%20from%202%20secs%20to%207-9%20secs%20will%20discourage%20us%20from%20using%20metadata.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20further%20advice%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

In an effort to improve search-ability of documents, I have created a metadata driven document library.  The files were originally in a library organized by folders.  The library contains just under 300 files.  We are using 2 managed metadata fields, each with under 200 choices in the term store.  

 

In the original library, the library screen load time was just under 2 seconds.  However, in the new library, the load time is more like 7-9 seconds.  It also takes longer to load more documents in the view as you scroll thru the documents.

 

I ran other tests, such as removing the metadata columns from the view - helped a little and switching the library to classic mode - not much of a difference.

 

I certainly see value in using metadata in a document library.  However, if it is going to hurt library performance, then it may not be worth the effort.

 

Has anyone else experienced this issue?  Were you able to solve the issue?

 

Thanks in advance

3 Replies
If you jump in with managed metadata you will hit some performance degradation but it also depends on what type of fields you use as well. You might also go into the list, and check indexed columns and see about adding in the managed metadata fields. Pretty sure you can index those as well, this might help improve your performance.

Thank you@Chris Webb giving this a try.  I'll report back on the findings.

Thanks for the suggestion, @Chris Webb.  I created 2 indexes for the library.  One that indexes both columns (primary & secondary) based on usage suggestions from the business owner.  The second with just the column I designated as secondary in the first index.  

 

At first, my timings looked encouraging.  However, the trends show no real changes.

 

Does this mean that, if I use metadata, I am going to see degraded performance?  Load times that go from 2 secs to 7-9 secs will discourage us from using metadata.

 

Any further advice would be appreciated.