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

Re: Query grid

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>,"pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Query grid
Date: 2006-04-03 14:51:30
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C99D9@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
 

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de] 
> Sent: 03 April 2006 15:29
> To: Dave Page
> Subject: Re: [pgadmin-hackers] Query grid
> 
> Dave Page wrote:
> >  
> > 
> > 
> >>-----Original Message-----
> >>From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de]
> >>Sent: 03 April 2006 14:50
> >>To: Dave Page
> >>Cc: edigeronimo(at)xtracards(dot)com; pgadmin-hackers
> >>Subject: Re: [pgadmin-hackers] Query grid
> >>
> >>IMNSHO this patch is rotten from the ground. wxGrid is known to be 
> >>flakey, extending its use is a bad idea.  The speed issue is not a 
> >>question of grid or non-grid, it's a question of virtual 
> data/display 
> >>management.
> > 
> > 
> > As you know, there is no alternative that can provide the other 
> > functionality that people want (copy/paste etc),
> 
> The old listview already _does_ support copying.

Only of complete rows. You cannot copy individual cells, columns or
arbitrary regions.

> and we've already seen
> > that the grid can be significantly faster than the list.
> 
> This is plain wrong. I never said the current listview 
> implementation is good; it isn't. But to rewrite it with 
> wxVIRTUAL or however the style is called is for sure easier 
> than doing it with wxGrid.

Actually you've said on a number of occasions that the current
implementation is limited by the OS's underlying controls; for example:

http://archives.postgresql.org/pgsql-performance/2005-10/msg00248.php

Which implies that we need a better control, not a fix to our code.


> > I know you will say that the tool has only one purpose from 
> your point 
> > of view, but regardless of that, pgAdmin *is* a generic 
> tool intended 
> > to meet the needs of the majority of it's hundreds of thousands of 
> > users, and that includes the query tool which many will be 
> comparing 
> > with SQL's Query Analyzer and similar programs.
> 
> Which can do better in exactly which aspect?

Copy/paste?

/D

Responses

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2006-04-03 15:05:37
Subject: Re: Query grid
Previous:From: svnDate: 2006-04-03 14:27:14
Subject: SVN Commit by dpage: r5069 - trunk/pgadmin3/src/ctl

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