How (and why) does the method of data import impact FMP 13 performance?
That is ... importing data from an external delimited text file vs. data from another table within the same FMP database.
I currently import text file data directly into a table with auto-enter calculation and/or standard calculation fields.
Is there a performance gain by instead:
1. importing the data into a dedicated "import" table, devoid of any calculations, and then
2. importing the data into a separate table that does contain the necessary calculation procedures
For reasons I won't explain here, the imported data must be written/stored in the new table.
This is a single user application, and does not involve FMP Server.