Skip to main content
Question

Formula Query Execution took too long - List All table

  • February 1, 2023
  • 0 replies
  • 207 views

We have a table with a bit over 9,000 records and 184 fields. Table size is 4.8 MB, with 150 MB of attached files, and the statistics screen says it is less than 1% full.

Recently, we have been getting the error "Formula Query Execution took too long" when attempting to load the List All report for this table. 

The table lists vehicle assignments, and we sometimes need to look back at assignment histories, so I would prefer not to delete any records.

Why would we be getting this error, and is there anything I can do to prevent it?

------------------------------
Amy Christensen
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Removing the field which has the formula query off the report will solve the issue.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------