Return to FileMaker.com
Execute SQL vs Filemaker calculated fields
I'd like to know if executing an SQL query is faster than using a filemaker calculated fields on a remote mysql database hosted on a webserver?
There two tables Clients & Invoices. Lets say I want to summarize total invoice amount per client. Which one of the two methods will calculate the result faster?
1. Execute SQL update statement sum(invoices.total) where client_code ="xyz" after every invoice created
2. Use filemaker calculated field in clients --> Total spent (Sum ( invoices::Total))
Has anyone experienced this ?
Retrieving data ...