Hi,
> As I mentioned in my previous email that we do not use server side cursor, so it won't add any
> limit on query.
>
> The delay is from database driver itself, it has nothing to do with pgAdmin4.
> Try executing the same query in 'psql', 'pgAdmin3' and third party tool which use libpq library as
> backend, you will observe the same behaviour.
It is not exactly truth... In v3 the query is executed, fetched and all rows are displayed, in v4 query is executed,
fetchedbut only 1000 records are displayed.
For me this idea of "load on demand" (which in reality is "display on demand") is pointless. It is done only because
themain lag of v4 comes from interface. I don't see any other purpose for it... If You know (and You do) that v4 can't
handlebig results add pagination like every other webapp...
And by the way You have a big leak in query tool - execute query with several thousands rows, scroll above 1000 mark
fewtimes, execute the same query, scroll above 1000 mark few times - repeat until You run out of memory or v4
crashes...
--
Tomek