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.
Subject
Views
Written By
Posted
3053
April 19, 2012 08:09AM
Re: 1000 Columns, 1000 Tables, or what?
1496
April 20, 2012 06:50PM
1277
April 23, 2012 08:10AM
1515
April 26, 2012 07:59AM
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.