[Phpmyadmin-devel] Zoom-search suggestions

[Marc Delisle]

Le 2011-06-17 18:16, Ammar Yasir a écrit :
> On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle <marc at infomarc.info> wrote:
> 
>> Ammar,
>> it works well so far!
>>
>> Suggestions:
>>
>> - As the default data label, use the display field if it exists (from
>> libraries/relation.lib.php, PMA_getDisplayField() )
>>
>> - For the title, instead of "Scatter Plot", give some indications (how
>> to zoom, how to click, etc) or give a link to get such indications
>>
>> - Is it possible to enlarge the size of the working zone? ideally, to
>> drag it by one of its corners?
>>
> 
> :) I'll try and look into it.
> 
> 
>> - You seem to prefetch the whole table and I'm concerned about response
>> time and memory issues for big tables (try it with the payment table and
>> no data restriction). When hovering over a dot, maybe fetch the rows one
>> by one with Ajax? Or use Ajax if there are more than a certain number of
>> rows.
>>
> 
> I was also very much concerned about this. This happens even with the
> 'Display chart' functionality in the browse tab. I pre-fetch the table for
> making the initial plot and store the data row for each point. One solution
> can be like: Now I'm generating query like 'Select * from table' which I'll
> change to 'Select x,y from table' and then when hovering or clicking over
> the plot, I'll fetch the data row.

Your solution of fetching just the needed columns will help, but we'll
need another safeguard for big tables. I'm thinking of a configurable
maximum of rows to fetch. Think of it, showing millions (or even
thousands) of dots won't make any sense.

> 
> 
>>
>> - Clicking on a point shows the whole row; is it possible to show a
>> pencil icon which would permit to bring another panel to edit the row?
>>
>> - Still thinking about a panning mechanism?
>>
>> - Any possibility of this feature for multi-tables?



-- 
Marc Delisle
http://infomarc.info