FieldDepartment
4 years agoQrew Member
Tables to Draw Formula Queries from: How Big is Too Big?
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
------------------------------
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
------------------------------