Postgres Pro
Downloads
Home   >   mailing lists

Re: Data grid: fetching/scrolling data on user demand - Mailing list pgadmin-support

From Dave Page
Subject Re: Data grid: fetching/scrolling data on user demand
Date
Msg-id CA+OCxoyn-142DkF0fJ30CdQyp53Lvnkh4Ybp2D_ZHD7YvmSnRw@mail.gmail.com
Whole thread Raw
In response to Data grid: fetching/scrolling data on user demand  (legrand legrand <legrand_legrand@hotmail.com>)
Responses Re: Data grid: fetching/scrolling data on user demand
List pgadmin-support
Tree view


On Sat, Oct 14, 2017 at 8:24 PM, legrand legrand <legrand_legrand@hotmail.com> wrote:
Hello,

Data grid is populated without any limit by default,
it could be a problem with very big datasets ...

To avoid this, it is possible to limit the number of rows retrieved,
but that limit is fixed, even if user tryes to scroll more data ...

Is scrolling data on demand supported ?

pgAdmin 4 loads data on demand (i.e. as the user scrolls) already. That's why it's significantly faster than pgAdmin 3. The batch size can be changed (from the default 1000) in the application config file by overriding the ON_DEMAND_RECORD_COUNT option in web/config_local.py in your installation.
 
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: No commit nor Rollback button
Next
From: dangal
Date:
Subject: Re: No commit nor Rollback button