<br><br><div class="gmail_quote">On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle <span dir="ltr"><<a href="mailto:marc@infomarc.info">marc@infomarc.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Ammar Yasir a écrit :<br>
><br>
><br>
<div class="im">> On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <<a href="mailto:marc@infomarc.info">marc@infomarc.info</a><br>
</div><div class="im">> <mailto:<a href="mailto:marc@infomarc.info">marc@infomarc.info</a>>> wrote:<br>
><br>
> Le 2011-06-17 18:16, Ammar Yasir a écrit :<br>
> > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle<br>
</div><div class="im">> <<a href="mailto:marc@infomarc.info">marc@infomarc.info</a> <mailto:<a href="mailto:marc@infomarc.info">marc@infomarc.info</a>>> wrote:<br>
> ><br>
> >> Ammar,<br>
> >> it works well so far!<br>
> >><br>
> >> Suggestions:<br>
> >><br>
> >> - As the default data label, use the display field if it exists<br>
> (from<br>
> >> libraries/relation.lib.php, PMA_getDisplayField() )<br>
> >><br>
> >> - For the title, instead of "Scatter Plot", give some<br>
> indications (how<br>
> >> to zoom, how to click, etc) or give a link to get such indications<br>
> >><br>
> >> - Is it possible to enlarge the size of the working zone?<br>
> ideally, to<br>
> >> drag it by one of its corners?<br>
> >><br>
><br>
> I used the jquery-ui plugin and implemented this.<br>
<br>
</div>Ammar,<br>
please push your repo.<br>
<div><div></div><div class="h5"><br></div></div></blockquote><div>I made some changes and pushed my work.<br> - Put a limit on the number of rows retrieved (500).<br> - Added two additional search criteria.<br> - A link that provides some help regarding how to use.<br>
- The working area can be dragged by the bottom right corner to enlarge it.<br> - Default label is taken from PMA_getDisplayField().<br><br>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 (<a href="http://highcharts.uservoice.com/forums/55896-general/suggestions/724254-scrolling-charts">http://highcharts.uservoice.com/forums/55896-general/suggestions/724254-scrolling-charts</a>)<br>
<br>Regards,<br>Ammar Yasir<br><br> <br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div class="h5">
><br>
> ><br>
> > :) I'll try and look into it.<br>
> ><br>
> ><br>
> >> - You seem to prefetch the whole table and I'm concerned about<br>
> response<br>
> >> time and memory issues for big tables (try it with the payment<br>
> table and<br>
> >> no data restriction). When hovering over a dot, maybe fetch the<br>
> rows one<br>
> >> by one with Ajax? Or use Ajax if there are more than a certain<br>
> number of<br>
> >> rows.<br>
> >><br>
> ><br>
> > I was also very much concerned about this. This happens even with the<br>
> > 'Display chart' functionality in the browse tab. I pre-fetch the<br>
> table for<br>
> > making the initial plot and store the data row for each point.<br>
> One solution<br>
> > can be like: Now I'm generating query like 'Select * from table'<br>
> which I'll<br>
> > change to 'Select x,y from table' and then when hovering or<br>
> clicking over<br>
> > the plot, I'll fetch the data row.<br>
><br>
> Your solution of fetching just the needed columns will help, but we'll<br>
> need another safeguard for big tables. I'm thinking of a configurable<br>
> maximum of rows to fetch. Think of it, showing millions (or even<br>
> thousands) of dots won't make any sense.<br>
><br>
> So like in table browse mode we can generate the plot for 500/250 rows.<br>
> Then if user wants we can replot with the next 500/250. Although I agree<br>
> it will only complicate the plot and its hard to make sense from the plot.<br>
> Or we can also ask the limit as input but I think the user might find it<br>
> annoying or unnecessary.<br>
<br>
<br>
<br>
</div></div>--<br>
<div><div></div><div class="h5">Marc Delisle<br>
<a href="http://infomarc.info" target="_blank">http://infomarc.info</a><br>
<br>
------------------------------------------------------------------------------<br>
EditLive Enterprise is the world's most technically advanced content<br>
authoring tool. Experience the power of Track Changes, Inline Image<br>
Editing and ensure content is compliant with Accessibility Checking.<br>
<a href="http://p.sf.net/sfu/ephox-dev2dev" target="_blank">http://p.sf.net/sfu/ephox-dev2dev</a><br>
_______________________________________________<br>
Phpmyadmin-devel mailing list<br>
<a href="mailto:Phpmyadmin-devel@lists.sourceforge.net">Phpmyadmin-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br>
</div></div></blockquote></div><br>