Re: Data grid: fetching/scrolling data on user demand
| От | Dave Page |
|---|---|
| Тема | Re: Data grid: fetching/scrolling data on user demand |
| Дата | |
| Msg-id | CA+OCxowSXn8kcWxK_BKaSF8zERqauQJvdSBdRTHMt4ZDfMFu8g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Data grid: fetching/scrolling data on user demand (Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>) |
| Ответы |
Re: Data grid: fetching/scrolling data on user demand
|
| Список | pgadmin-support |
On Tue, Oct 17, 2017 at 6:36 AM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
On Tue, Oct 17, 2017 at 2:22 AM, legrand legrand <legrand_legrand@hotmail.com> wrote:How long does it take in your environnment
to fetch the 1000 first records from
select * from information_schema.columns a,information_schema.columns bI didn't run it because on my environment just count from information_schema.325columns gave me 7325 records (Cross join will be 7 * 7325 records , and obviously that will take huge amount of time)
Right - exactly as it does in psql (the command line interface). pgAdmin can't make the database engine faster - all it can do is retrieve and display the results as efficiently as possible, once the server makes them available.
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
В списке pgadmin-support по дате отправления: