[Phpmyadmin-devel] Zoom-search suggestions

[Ammar Yasir]

On Mon, Jun 20, 2011 at 12:36 AM, Tyron Madlener <tyronx at gmail.com> wrote:

> On Sun, Jun 19, 2011 at 8:58 PM, Ammar Yasir <ammaryasir.88 at gmail.com>
> wrote:
> >
> >
> > On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <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>
> >> > 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.
> >>
> >> >
> >> > :) 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.
>
> for the 'Display chart' feature I thought of using a zoom feature like
> this: http://www.highcharts.com/demo/dynamic-master-detail
>

What if we make 2 sql queries to find out the min and max value of the
> 'x-axis', then select like 100-200 values that are equally distributed
> over the x-axis and display those?
>
> Hope that was understandable.
>
>
Sampling is okay but only if we use a good sampling technique. There might
be the case where we miss what the user is looking for.
In partitioning we wont miss but might complicate matters.

> >
> >>
> >> >
> >> >
> >> >>
> >> >> - 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
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> 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
> >
> >
> >
> ------------------------------------------------------------------------------
> > 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
> >
> >
>
>
> ------------------------------------------------------------------------------
> 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/20110620/7c632d9d/attachment.html>