Performance issue while Retiving data using custom options

Hi Team,   On my page I have a data grid 2 with data source as microflow, in that, I have retrieved the object using custom options where it will retrieve the first 20 objects out of 2500 objects from DB based on server side pagination, but this DS in that page is causing the performance issue. The page is taking 3sec to load. Can anyone suggest me to optimize this code?
1 answers

HI @Ajitha!

How are you? 

Prefer using Xpath in Data Grid 2 because it handles pagination automatically and improves performance.