Forum Discussion

Re: Formula Syntax Error Question

The table the formula is querying has 42,000+ records.

------------------------------
Daniel Johnson
------------------------------

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    You would probably have to reach out to the care team but I think right now they are throttling the use of queries on larger table sizes. 42,000 records is not really that big for Quickbase but they seem to be going very cautiously on these formulas. They are afraid the Formula Queries will hurt the performance of the app and the platform.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain

      I may be partly to blame for the throttling.  I opened a support case because all of my apps in the realm went offline when I tried to save a formula query.  a couple days after they closed the ticket is when I saw that message for the first time.  

      It's interesting that they can present something in one of the empower workshops this year and show a query working on a data set of over 300k records, but cannot deliver that performance in production.



      ------------------------------
      Paul Peterson
      ------------------------------