Forum Discussion

JonFroderberg's avatar
JonFroderberg
Qrew Cadet
4 years ago

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

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." & URLEncode([Job]) & "}AND{27...
formula queries
MikeTamoush's avatar
MikeTamoush
Qrew Elite
4 years ago
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's avatar
JonFroderberg
Qrew Cadet
4 years ago
Hi Mike-
Yes, this is a fairly busy table.  80K+ records and 244 fields.

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Elite
    4 years ago
    I'd be willing to be it is the size of the table. I have not found a work around or a way to get it to query my tables that big. Please post back if you come up with a solution!


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