0 Replies Latest reply on Feb 23, 2009 4:46 PM by Slamdunk

    Execute SQL vs Filemaker calculated fields

    Slamdunk

      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 ?