[Phpmyadmin-devel] Zoom-search suggestions

[Ammar Yasir]

On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle <marc at infomarc.info> wrote:

> Ammar Yasir a écrit :
> >
> >
> > On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc at infomarc.info
> > <mailto:marc at 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 at infomarc.info <mailto: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 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110621/e67ddc97/attachment.html>