On Thu, Jun 16, 2016 at 2:35 PM, Dave Page <dpage@pgadmin.org> wrote:
Thanks, patch applied.
However, whilst I was testing, I saw just how slow the tool is:
SELECT * FROM pg_attribute
In a PEM database, returns 8150 rows. In pgAdmin 3, this is timed at 676ms on my laptop. In pgAdmin 4, the busy spinner runs for approx 5 seconds, then the whole UI freezes. I then have to wait a further 3 minutes and 46 seconds(!!!!) for the operation to complete. Once loaded, scrolling is very sluggish.
Please make this your top priority - and if you have incremental improvements, send them as you have them.
Sure.
Below is my initial finding while running "SELECT * FROM pg_attribute" on PEM database, returns 8498 rows:
Fetching data from the server side took consistent time and it took 3-4 secs.
Create/Render Backgrid without pagination : 1 minute
Create/Render Backgrid with pagination (50 items per page): 469ms
Create/Render Backgrid with pagination (500 items per page): 3 secs
Create/Render Backgrid with pagination (1000 items per page): 6 secs
Create/Render Backgrid with pagination (3000 items per page): 22 secs
Create/Render Backgrid with pagination (5000 items per page): 36 secs
OK, so I guess diving into Backgrid is the next step. Are there any profiling tools that could be used?
Can we use infinity scrolling in case of no pagination?