Skip to main content
September 11, 2025
Question

Limit read only grid entries due to query timeout

  • September 11, 2025
  • 5 replies
  • 0 views

I have a read only grid that is supposed to populate with all entries in a record with a certain flag and put that into a read only grid. The problem I run into is that despite the grid displaying only 3 entries at a time, the query keeps timing out because of how large the number of entries is. I need all entries to be available for my functionality and it is set to load as async. Is there a way to bypass the query timeout error?

5 replies

shubhama926776
September 12, 2025
I need all entries to be available for my functionality

May I know how you are querying data and why you need all entries?

Could you share your gridField data parameter definition?

Is there a way to bypass the query timeout error?

There is no direct way of doing this, but based on the query, we can optimize it.
Share more details.

harshas2775
September 12, 2025
Is there a way to bypass the query timeout error?

Only way is to optimise the data query and batch the dataset. How is the 'data' parameter of the gridField() configured? Is it referencing a record directly or some rules? 

mikes0011
Brainy
September 12, 2025

Please share some code snippets and/or screenshots with us - helpful in understanding your attempted setup.

I understand that there are sometimes some overriding requirements, but what I've found in cases like this is *usually* that a particular view (at least, it sounds like you're querying a view) is overloaded with the "trying to do everything at once" effect.

I need all entries to be available for my functionality

Why exactly?  What functionality does this fulfill, and how sure are you that querying "all entries" is the only way to do it?

amitm956894
September 12, 2025

Are you pulling the data from related records and using pagination as well?
If you can share query and parameter of your gridField , we can suggest better. Else, try optimize the code first. But make sure you are not pulling unwanted data too.

stefanhelzle0001
September 15, 2025

What kind of "query" is that?