AnsweredAssumed Answered

Execute SQL vs Filemaker calculated fields

Question asked by Slamdunk on Feb 23, 2009

Title

Execute SQL vs Filemaker calculated fields

Post

Hi,

 

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?

 

Example:

 

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

OR

2. Use filemaker calculated field in clients --> Total spent (Sum ( invoices::Total))

 

Has anyone experienced this ?

Outcomes