This content has been marked as final. Show 1 reply
Thanks for posting.Are their any field types that would cause a relationship to slow down? (i.e., Date, DateTime, etc)?---I wouldn't lean toward the relationships as the issue here. Just to verify, what is the benchmark of the speed issues vs creating a file in a table that is 'good'? As a test, try creating a Save a Copy as > Clone (No records) file and try adding new records. Does the issue persist? If not, try saving the file as a Compact Copy and see if this affects performance. If applicable, I would go to File > Manage > External Data Source and remove any dead file references.Do relationships run in FileMaker Server or in the Client? (On version 8? 9? 10?)---Unfortunately, I don't have an answer for this. This question concerns the inner workings of the software of which I am not privy toRecommended Hardware under our situation?---You should be ok with the recommended hardware (or above) listed here:Is it better to have MySQL on the same computer as FileMaker Server or a different computer?---I have seen configurations with both apps occupying the same machine (taking into account that there are enough resources for both). However, it is recommended that FileMaker Server sit on a dedicated machine.Is there any estimate on when the crashing when sorting large datasets from a MySQL (ODBC) connection will be fixed?---It's policy that FileMaker does not comment or speculate on updates, fixes, future releases, etc. I'd hate to offer any estimation, regardless, as fixes/features that may be lined up could get dropped at the last minute and not make it into a release/fix and I'd hate to set false expectations.Will it be changed to sort MySQL (ODBC) data through the query in the connection rather than cache all the data then sort it in FileMaker?---While the answer above applies, I would suggest adding a feature requestWhen running FileMaker Server does the MySQL (ODBC) sort take place on the Server or on the Client requesting the sort?.--This is the same as the second question. This type of question is on the engineering level of FileMaker of which we are not privy to.Hope this helps,tsturtleFileMaker, inc.