Re: Fixed RM #1356
От | Akshay Joshi |
---|---|
Тема | Re: Fixed RM #1356 |
Дата | |
Msg-id | CANxoLDfKZ2E3HfyRge3KOn9oQ1k+=QknOfAue7AFT+HHP+ENrg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Fixed RM #1356 (Khushboo Vashi <khushboo.vashi@enterprisedb.com>) |
Ответы |
Re: Fixed RM #1356
(Dave Page <dpage@pgadmin.org>)
|
Список | pgadmin-hackers |
On Thu, Jun 16, 2016 at 5:47 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:
On Thu, Jun 16, 2016 at 5:07 PM, Dave Page <dpage@pgadmin.org> wrote:On Thu, Jun 16, 2016 at 12:19 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:On Thu, Jun 16, 2016 at 4:42 PM, Dave Page <dpage@pgadmin.org> wrote:On Thu, Jun 16, 2016 at 12:04 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:Hi DaveOn Thu, Jun 16, 2016 at 2:42 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote: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_attributeIn 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?How would add row work then?Yeah, in this case user has to wait till the last record to load. :(Btw, I was thinking of https://github.com/bhvaleri/backgrid-infinator
This seems to be the good option.
--Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Akshay Joshi
Principal Software Engineer
Phone: +91 20-3058-9517
Mobile: +91 976-788-8246
Mobile: +91 976-788-8246
В списке pgadmin-hackers по дате отправления: