AnsweredAssumed Answered

Performance: Auto-enter vs Lookup vs Execute SQL?

Question asked by agisllc on Apr 4, 2017
Latest reply on Apr 10, 2017 by agisllc

Hi Everyone,

 

We are about to optimize the data file for a solution containing 100 tables+. One of our to-dos is to convert lookups to auto-enters because it is our understanding that auto-enters are faster. We also plan to convert many of the "related field" auto-enters to SQL queries rather than using relationships for the same reason. Does anyone happen experience with similar efforts? Specifically:

 

• Are auto-enters actually faster than lookups and, if so, by how much?

• Is using SQL to gather a related record's field faster than using a relationship and, if so, by how much?

 

Any insight would be appreciated. 

 

Thanks,

 

Michael Bethuy

Outcomes