Skip to main content
Question

Tables to Draw Formula Queries from: How Big is Too Big?

  • December 16, 2021
  • 0 replies
  • 79 views
Forum|alt.badge.img
Hello,

I'm curious if anyone has a sense at what point a table is just too large for attempting to use a formula query on it. I'm currently trying a Size(GetRecords()) on a table with 3-4 fields in the query, and it seems like it just simply stopped working at over 40,000 records (and yes, this is after trying different iterations of which query comes first, in order to maximize performance). Does that match up with anyone else's experience?

------------------------------
Field Department
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+20
  • MikeTamoush
  • Registered
  • December 17, 2021
I'm trying to find duplicates in a table using a similar query, and am getting 'Formula Query Execution Took too long".

My table has 87k records so, perhaps formula queries only work on small tables?


------------------------------
Mike Tamoush
------------------------------
Terms & ConditionsAccessibility statement