On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle marc@infomarc.info wrote:
Ammar Yasir a écrit :
On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Le 2011-06-17 18:16, Ammar Yasir a écrit : > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle <marc@infomarc.info <mailto:marc@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 used the jquery-ui plugin and implemented this.
Ammar, please push your repo.
I made some changes and pushed my work.
- Put a limit on the number of rows retrieved (500). - Added two additional search criteria. - A link that provides some help regarding how to use. - The working area can be dragged by the bottom right corner to enlarge it. - Default label is taken from PMA_getDisplayField().
For the panning feature, I went through the forums at highcharts and they might be coming up with it by the end of this month (beta release) or next month ( http://highcharts.uservoice.com/forums/55896-general/suggestions/724254-scro... )
Regards, Ammar Yasir
> > :) 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.
So like in table browse mode we can generate the plot for 500/250 rows. Then if user wants we can replot with the next 500/250. Although I agree it will only complicate the plot and its hard to make sense from the
plot.
Or we can also ask the limit as input but I think the user might find it annoying or unnecessary.
-- Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel