[wp-hackers] HyperDB - worth the trouble?

[Baki Goxhaj]

>
> The good news is in almost all cases WP Multisite already splits sites
> across tables
>

That would be cool then, but is this really the case? Otto? :)

Kindly,

Baki Goxhaj
www.wplancer.com | proverbhunter.com | www.banago.info<http://proverbhunter.com>


On Thu, Mar 8, 2012 at 4:49 PM, Jeremy Clarke <jer at simianuprising.com>wrote:

> On Wed, Mar 7, 2012 at 6:51 AM, Baki Goxhaj <banago at gmail.com> wrote:
>
> >
> > I just had this idea that, a smaller database with fewer records will
> > perform better then a bigger one, so by splinting the content of each
> site
> > into it's on database, but the same MySQL server, would be better. But
> > seems I was wrong.
> >
>
> Having the traffic hit different *tables* (wp_posts, wp_term_relationships)
> makes an enormous difference, unlike having separate *databases*, which
> performance-wise is the same as if they were in different tables of the
> same DB. The good news is in almost all cases WP Multisite already splits
> sites across tables, so the performance benefits are automatic.
>
> --
> Jeremy Clarke • jeremyclarke.org
> Code and Design • globalvoicesonline.org
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>