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.