MySQL Forums
Forum List  »  Optimizer & Parser

Re: 1000 Columns, 1000 Tables, or what?
Posted by: Rick James
Date: April 20, 2012 06:50PM

> it's a time-bomb
I like that phrasing. Yeah, WordPress will first slow down, then possibly crash because of its proliferation of tables (hence files).

> So I started planning a few changes.
Starting with WP source code?

9 tables per user could become 9 tables _total_. Add a userid to each table (roughly speaking), and add it to the beginning of every index.

As for the "all blogs" blogs -- create a fake user for such, then do a UNION between the real user and the AllBlogs user.

Options: ReplyQuote

Written By
Re: 1000 Columns, 1000 Tables, or what?
April 20, 2012 06:50PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.