Re: Query grid - Mailing list pgadmin-hackers

From Andreas Pflug
Subject Re: Query grid
Date
Msg-id 443141B4.6070404@pse-consulting.de
Whole thread Raw
In response to Re: Query grid  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: Query grid
List pgadmin-hackers
Dave Page wrote:
>
>
>
>>-----Original Message-----
>>From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
>>Sent: 03 April 2006 16:06
>>To: Dave Page
>>Cc: pgadmin-hackers
>>Subject: Re: [pgadmin-hackers] Query grid
>>
>>If the current implementation isn't rewritten, I'll commit a virtual
>>rewrite of wxListView based ctlSqlResult (as soon as I find the time,
>>which will certainly not be this week). It will probably require more
>>work on frmQuery (remove the ctl filling loop, no need for the second
>>timing display) than on the ctl itself, making it incompatible to
>>ctlSqlResult implementations that are not managing their data
>>virtually.
>
>
> Yeah, well hold fire on that - I just found what broke it, and now get
> (second of 2 runs in each version, from the same server):
>
> 1.5.0:
>
> -- Executing query:
> select * from pbx_log limit 10000
>
> Total query runtime: 8187 ms.
> Data retrieval runtime: 1062 ms.
> 10000 rows retrieved.

A correct implementation has *no* retrieval time, just some microseconds
of setting up the virtual control.

Regards,
Andreas


pgadmin-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Query grid
Next
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r5070 - trunk/pgadmin3/src/ctl