AnsweredAssumed Answered

performance affects from subsummary reports, FMP10-Advanced/OSX 10.5

Question asked by StacyMc on Oct 7, 2009
Latest reply on Oct 22, 2009 by TSGal

Title

performance affects from subsummary reports, FMP10-Advanced/OSX 10.5

Post

I've have a database that has a little less than 100K records total, saved in various fp7 files, living on a new FMP server.

 

Currently there are reports created by using scripts that perform finds. The found info is displayed in a subsummary layout.

 

My question is would there be any performance issues if these reports existed as static subsummary reports? Instead of performing finds ever time. The static reports would have a table relationship that refers to a global field, which can be changed (usually using a set value list). I'd likely have 4-5 summary reports living in unseen layouts of commonly used fp7 files. 

 

Hope this isn't too abstract a question.

 

Thanks for any help.

Outcomes