Advise for Performance Issue & Getting Timeout Error 504

Hi,

We are currently develop a Calendar App (very much like the default calendar, with some extra features) and I’m facing serious performance issue because I’m getting ALL the data without any filtering. I would like to filter the data based on specific date range (only display the data of current month / week) but it seems not possible based on this ticket Query Column Value by Range - #2 by Scott-monday.com

Is there any other advise / work around for this issue?

This is my query:

query ($boardIds: [Int]) {
    boards (ids:$boardIds) { 
       name 
       items { 
           id
           name
           group { color } 
           column_values { id title text value } 
       } 
       groups {
           id
        }
    }

}

Br, YarHuoy

Hi

Is there any update??

Br, YH

If you’re returning a large amount of data, you may see the request time out.

Instead, I’d recommend using the limit and page parameters to page through the results. This will let you split the items into multiple API calls.

If you’re only interested in the date information, you can make your query more lightweight by filtering to just a specific column ID. Here’s an example:

query ($boardIds: [Int]) {
    boards (ids:$boardIds) { 
       name 
       items (limit:100) { 
           id
           name
           group { color } 
           column_values (ids:["date4"]) { id title text value } 
       } 
       groups {
           id
        }
    }
}