[wp-hackers] HyperDB - worth the trouble?

[Jeremy Clarke]

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