MySQL Forums
Forum List  »  Optimizer & Parser

Re: 1000 Columns, 1000 Tables, or what?
Posted by: Fernando Oliveira
Date: April 23, 2012 08:10AM


It's exactly the source-code thing. I'm building a new system, just didn't decide yet if it should become a Plugin for Wordpress, for another CMS, or standalone. Still starting the development.

I like the UNION idea, though I'm thinking of making it a bit different. I'll have a few tables taking car of the relationships between Users and Blogs, between Posts and Blogs, and between Blogs themselves. This way I can create a better Tree Structure, and I can trust it'll be optimized since I'll be using just 2 or 3 tables with 2 or 3 fixed-size, indexed columns each.

I believe this will be the best option to deal with this much information, any other ideas?

Options: ReplyQuote

Written By
Re: 1000 Columns, 1000 Tables, or what?
April 23, 2012 08:10AM

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.