[Phpmyadmin-devel] about choosing table layout for pmadb

[Zeeshan Mughal]

:-)
--------------------------------------------------
Best regards,
Zeeshan Mughal
Email:  zeeshanmughal at ieee.org
Web:  http://www.zixan.info


On Mon, Jun 8, 2009 at 11:18 AM, Marc Delisle <marc at infomarc.info> wrote:

> Michal Čihař a écrit :
> > Hi
> >
> > Dne Fri, 05 Jun 2009 05:32:02 -0400
> > Marc Delisle <marc at infomarc.info> napsal(a):
> >
> >> Yes there are downsides for each alternative. Another downside for the
> >> EAV model is that at user login (session initialization) we need to read
> >>   all the rows holding the user prefs for this user, instead of just one
> >> read if each option has its own column.
> >
> > With index on login name, selecting several rows should be quite cheap.
> >
> >> As mentionned in one of the links I gave, the EAV model also makes it
> >> difficult to code the possible choices for an option, for example into
> >> an ENUM.
> >
> > Okay, I probably can live with either of solutions. Both have downsides
> > and advantages.
>
> I guess it's up to Zeeshan to decide now.
>
> >
> >> About upgrading, I expect Zeeshan to implement a feature to auto-create
> >> and auto-upgrade the table (which could be extended to all of our pmadb
> >> tables).
> >
> > It should be coded with this in mind.
>
>
>
>
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> 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/20090608/5273acf2/attachment.html>