I always like to have server paging on for mass amounts of data. Not sure what version you are on, but it is currently broken in 2025.2. There’s a hotfix in 2026.1 that fixes it, but it’s not available to older versions yet. I am working with support to get a resolution.