Skip to main content
Solved

How to optimize the query time to get the 20K+ items from the board with 5 mirror columns ?

  • June 19, 2026
  • 2 replies
  • 548 views
S

Hi, 


How to optimize the query time to get the 20K+ items from the board with 5 mirror columns ?
I am trying to get the 20K+ items from the boards having the 5 mirror columns.
As the no. of items is huge it takes significant amount of the time to get all the data with 20K+ /500 = 40+ calls.
Hence currently it is not possible to filter data.
These whole data is being used to generate the custom type report requested by the client.
I was trying to filter the data on the basis of the date column but as it is of the type mirror it is impossible to perform server side filtering ?

​@OmerK 

Best answer by xatxat

a strategy is to first iterate over the result pages without fetching the actual items, just to collect the page cursors. then you fetch the pages with the actual data in parallel.

 

- simon

2 replies

xatxat
Forum|alt.badge.img+1
  • xatxat
  • Participating Frequently
  • Answer
  • June 19, 2026

a strategy is to first iterate over the result pages without fetching the actual items, just to collect the page cursors. then you fetch the pages with the actual data in parallel.

 

- simon

    S
    • Shreyas
    • Author
    • New Participant
    • June 19, 2026

    a strategy is to first iterate over the result pages without fetching the actual items, just to collect the page cursors. then you fetch the pages with the actual data in parallel.

     

    - simon

    Thanks man, this looks like Gold solution. I will implement and test this approach asap .

     

    Terms & ConditionsAccessibility statement