It takes a very long time to query the internal table with the tablenames, fieldname and field types, if the databasefile has lots of tables in it. There
1. create a databasefile with about 130 tables, each table holding 230 fields.
2. Query the internal FileMaker table to get the tablenames, fieldnames, etc.
It takes between 60 to 120 seconds.
Expected Result: it should be much faster.
Actual Result: It is slow.
This is FileMaker Server 15 on Windows 7.
SELECT DISTINCT \"FieldID\", \"FieldName\", \"BaseTableName\", \"FieldType\" From FileMaker_Fields,FileMaker_Tables WHERE FileMaker_Tables.TableName = Filemaker_Fields.TableName
This should list all fields with ID, name, table and type in the databases.
MBS Plugin uses this to learn about fields for Audit function.