Formula Query Error - The way this formula is built will take too long to process.

Question

Is URLEncode() not functional inside of a Formula Query? When I attempt to use it, I receive this error message.
Here is my formula:
Size(GetRecords("{52.EX." &amp; URLEncode([Job]) &amp; "}AND{276.XEX.2}AND{276.XEX.3}AND{276.XEX.5}AND{55.EX.''}", [_DBID_FABRICATIONS]))// fid: 52 [Job]// Issued For Fabrication Status// fid: 276 [Related IFF Status] is not equal to:// 2 - On Hold// 3 - Cancelled// 5 - Prerelease// fid: 55 [Scope Item Name] is equal to nullTrying to avoid creating a table to table relationship to get this value. I'm getting this same error on another formula query to a different table where I am also using URLEncode().
------------------------------Jon FroderbergPRIME DeveloperHarder Mechanical Contractorshttps://www.harder.comPortland, OR801.946.0576------------------------------

jonfroderberg · Answer

It appears I will not be able to use formula query for my need as the table being queried has too many records and/or fields. I will switch tactics and implement a table relationship to get the value I need. Some guidance in the Formula Query documentation would be helpful as to what record count or table complexity may be too much for the function(s) to handle.

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------

markshnier__you · Answer

I doubt it has to do with URLEncode.&nbsp;
Here are some tips that might help but your table maybe too large for Formula Queries to handle.&nbsp;
https://help.quickbase.com/user-assistance/formula_queries.html#Performance------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

miketamoush · Answer

I get that error a lot when I'm trying to find duplicate values in a large table (30,000+ records).

Are you querying a large table?

------------------------------
Mike Tamoush
------------------------------

jonfroderberg · Answer

Thank you Mark! I will read through this article.

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------

jonfroderberg · Answer

Hi Mike-Yes, this is a fairly busy table.&nbsp; 80K+ records and 244 fields.------------------------------Jon FroderbergPRIME DeveloperHarder Mechanical Contractorshttps://www.harder.comPortland, OR801.946.0576------------------------------

Forum Discussion

Formula Query Error - The way this formula is built will take too long to process.

6 Replies