Re: Unhandled exception in PGAdmin when opening 16-million-record table - Mailing list pgsql-general

From Dave Page
Subject Re: Unhandled exception in PGAdmin when opening 16-million-record table
Date
Msg-id AANLkTim_GAKBfjnzwwasC7=ig3Z=_9mrPaLPc-T=G=gG@mail.gmail.com
Whole thread Raw
In response to Re: Unhandled exception in PGAdmin when opening 16-million-record table  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Responses Re: Unhandled exception in PGAdmin when opening 16-million-record table
List pgsql-general
On Sat, Oct 30, 2010 at 2:45 PM, Peter Geoghegan
<peter.geoghegan86@gmail.com> wrote:
> On 30 October 2010 11:26, Dmitriy Igrishin <dmitigr@gmail.com> wrote:
>> Hey all,
>>
>> Why not to use MVC approach by implementing a model, which uses, e.g.
>> scrollable cursors? I believe that wxWidgets supports MVC.
>
> I've seen that behaviour before in similar applications, but it had a
> major downside: the number of rows returned was not known in advance
> of scrolling down to the last one. So you couldn't visualise the size
> of the record set based on the size and relative position of the
> scrollbar.

That is basically how it works (MVC), albeit without using cursors;
for both the reason you state and because part of the point of the
tool is to tune queries and using cursors to do that completely messes
up any timings we might get.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Which variant to choose?
Next
From: Martijn van Oosterhout
Date:
Subject: gitweb error?