[wp-hackers] Multiple options vs. one large serialized option

[Viper007Bond]

Nope, the array is a constant size and will only grow if I add support for
additional video sites.

On Fri, Aug 8, 2008 at 6:44 AM, Andy Skelton <skeltoac at gmail.com> wrote:

> On Fri, Aug 8, 2008 at 7:04 AM, Viper007Bond <viper at viper007bond.com>
> wrote:
> > So what's the "cutoff" where it becomes more efficient to break it up
> than
> > store it in one big long serialized string in the database? Or is there
> one?
> > It'd be easier for me to store it all in one option, but I'm not sure
> what
> > would be best from a performance standpoint.
>
> It's a question of scaling. What makes the array grow?
>
> Does the array have a relatively constant size? If the plugin only
> stores its configuration, a single options row is ideal for that.
>
> Does the array grow every time a video is added to a post? In that
> case, don't put the post-related stuff in options! Use postmeta.
>
> Andy
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>



-- 
Viper007Bond | http://www.viper007bond.com/ | http://www.finalgear.com/