Re: Opening queries in new window, record caching when scrolling

Поиск
Список
Период
Сортировка
От Murtuza Zabuawala
Тема Re: Opening queries in new window, record caching when scrolling
Дата
Msg-id CAKKotZTYtgzA_mNFCLUEyJa60dPY3ZQs7AzNH+ByUEDB+KsANA@mail.gmail.com
обсуждение исходный текст
Ответ на Opening queries in new window, record caching when scrolling  (Russell Mercer <rmercer@getspatial.com>)
Список pgadmin-support
There is a setting you need to change to open query tool in new window.

Goto: 
'File' -> 'Preferences' -> 'SQL Editor' -> 'Open in new browser tab' 
(Set this option to True)

Inline image 1

Regarding loading the result at once, loading the result  in chunks helps us improve the performance in server-client architecture.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Thu, Jul 20, 2017 at 6:36 AM, Russell Mercer <rmercer@getspatial.com> wrote:

Hi,

One of the items that was noted in the release of 1.6 was the ability to move queries into a new window, allowing for use on multiple screens.  I was wondering if anyone has been able to make this work.  I've given it a shot, but seem to be missing a step in the process.

The one way I've seen to open a new window is by Right Clicking on the pgAdmin 4 logo at the top left, and choosing the option to Open in a New Window.  The result of this is a new window, but in the form of a tab created in the existing window.  Is there a way to break that out separately to its own window?  I thought with the beta version that Dave Page released shortly before 1.6 was released, that I had gotten this to work, but now I'm not sure.

The other feature I wonder about is whether there is a setting to load the entire result into the window at once.  Right now, when I run a query, that returns say 13000 rows, it runs successfully.  When I grab the scroll bar to scroll to the bottom, it runs down through about 1000 records, then the scroll bar jumps halfway back up again, as it has obviously loaded another batch of records into the cache.  Is there any setting to change so that I can scroll to the bottom of the results without having to continually load records into the cache?  Any input would be much appreciated.

For tech details, I'm running this on a Windows 7, Intel i7, 16GB RAM.

On a personal note, I want to say that the 1.6 release of pgAdmin4 is a huge step for the software.  It is far more stable, loads faster, and seems to be approaching parity with what pgAdmin3 offered.  As someone who was pretty critical of the initial release of the software, I want to acknowledge that it is clear the developers have been working hard to address the concerns that were expressed.  It is very much appreciated.

Thanks,

Russell


В списке pgadmin-support по дате отправления:

Предыдущее
От: Russell Mercer
Дата:
Сообщение: Opening queries in new window, record caching when scrolling
Следующее
От: Ashesh Vashi
Дата:
Сообщение: Re: Opening queries in new window, record caching when scrolling