Re: [pgadmin-hackers] Some remarks to pgadmin III

[Andreas Pflug]

claus wrote:

Is there still some hope :-))

Adam H. Pendleton wrote:
 

I assume when you say that sorting the rows would require a re-query, 
you are referring to a new SQL statement with a "ORDER BY" clause.  I 
think what he's asking for is perfectly do-able without a new query.  
Since the rows are stored in a grid control of some sort, then you 
should be able to sort the rows using the function of that grid control 
itself.  This sort would have *no* impact on the actual data, where it 
is in the database, etc.  I would imagine that this sort of this would 
be possible only if the wxWindows control used to display the data 
supported it.  I will do some reasearch and see if it can be done.
   

That is when I said that data is around in some form. 
I just tested a table with 13000 entries ... 
after "refreshing" it **realy** seems to me all data is  on my PC.
When scrolling there is absolutely **no** freeze, flicker or
other indication of data being fetched in a lazy way.

Thanks, I appreciate the compliments. It proves that I implemented it 
smoothly. You might notice a delay it when you're connected to the 
server over a slow line.

Look at the code if you don't believe that data is really loaded on 
demand. Every time a row is touched that's not in the cache 
(!line->cols), sqlTable::GetValue will consult the Dataset for the 
column values of that row.

Also the sliders of the grid indicate perfectly where are in the
data ... ok that might be done using a "total row count" value.
Fortunately libpq supplies this value. sliders that don't represent the 
position are a Mega-PITA, degrading the slider to a "next page" button. 
I'd never code stuff like that.

For those who worked with tools doing on demand row fetch.
(I think Delphi 3 Datamanger and Free Toad for Oracle)
they know what I mean.
Poor software all over the world....

Regards,
Andreas


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly