AnsweredAssumed Answered

Master record list can negatively impact performance?

Question asked by BillisSaved on Oct 27, 2016
Latest reply on Oct 27, 2016 by Vaughan

Good afternoon everyone,

 

I hope your day is going well. I was recently watching the Under the Hood: Server Performance presentation from FileMaker Devon 2016, presented by Jon Thatcher, and I'd like to find more information on a particular topic that he mentioned during his talk. Assuming I understood him correctly, which may not be the case, there is a Master Record List consisting of a small amount of data representing each record of a layout's underlying table. This information is moved from the server to the client when a layout is loaded, even if the layout is empty. Jon mentioned that viewing a layout based on a table with say one million records could have a dramatic negative impact on performance. Does anyone know of a knowledgebase article or white paper that explains this FileMaker attribute/process in detail? Thanks in advance for any assistance and/or advice you are willing to provide!

 

God bless,

 

Bill

Outcomes