Forum Discussion
MarkShnier__You
Qrew Legend
I ran into that same issue.
I think the problem is that the formula query needs to run 87,000 times against a record set of 87,000 records. So it has to touch 87,000×87,000 records which is touching 7 billion records.
So the formula Queries can be incredibly useful but you kind of have to plan ahead because I imagine it's possible that a Formula Query would work initially for a new app but as the data builds up it may stop working.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I think the problem is that the formula query needs to run 87,000 times against a record set of 87,000 records. So it has to touch 87,000×87,000 records which is touching 7 billion records.
So the formula Queries can be incredibly useful but you kind of have to plan ahead because I imagine it's possible that a Formula Query would work initially for a new app but as the data builds up it may stop working.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
PaulPeterson1
3 years agoQrew Assistant Captain
I ran into similar issues as well and may be partially to blame for the error messages. I used a bit of code from the formula query workshop from Empower 2021 and when I tried to save the field with the query it took every app in my realm down for about 10 minutes. Shortly after Quickbase closed my care case I noticed the error message appearing in apps where I was trying to use formula queries. Quickbase claimed if you try to use formula queries in a table that has several relations (cross app relationships in particular) that the query may use too much of the system's resources.
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------