Hi,
Chipping in here for my coworker Jaycee.
We have a table with a quite some columns, and roughly 6k rows. We have removed all Expressions - and this has increased performance tremendously. Toggling prefilters and searching is now quite acceptable (not good enough) - but when jumping to the last page, the query is quite expensive.
When we look at the query from the debugger and remove the last line
<rest of the query>
ORDER BY t1.[closing_time] DESC, t1.[shipment_id] ASC, t1.[vgm_closing_time] DESC
WITH the offset - the query takes roughly 15 seconds, but when we remove the OFFSET, it is faster.
The table performs fairly ok, but when jumping to the last page, it lags (the offset being in play). This only happens in universal gui. WEB gui is way faster. Other elements like the prefilters are comparable.
Any thoughts on this?
Blommetje