21 Jun
2011
21 Jun
'11
1:38 a.m.
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-scrolling-charts ) 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 >