Skip site navigation (1) Skip section navigation (2)

Re: Query grid

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Query grid
Date: 2006-04-03 15:39:32
Message-ID: 443141B4.6070404@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-hackers
Dave Page wrote:
>  
> 
> 
>>-----Original Message-----
>>From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)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


In response to

Responses

pgadmin-hackers by date

Next:From: svnDate: 2006-04-03 15:55:57
Subject: SVN Commit by dpage: r5070 - trunk/pgadmin3/src/ctl
Previous:From: Dave PageDate: 2006-04-03 15:32:07
Subject: Re: Query grid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group