Forum Discussion

AmyChristensen1's avatar
AmyChristensen1
Qrew Trainee
2 years ago

Formula Query Execution took too long - List All table

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
------------------------------

1 Reply

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    Removing the field which has the formula query off the report will solve the issue.

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