Re: 1000 Columns, 1000 Tables, or what?
Rick,
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?
Subject
Views
Written By
Posted
3094
April 19, 2012 08:09AM
1520
April 20, 2012 06:50PM
Re: 1000 Columns, 1000 Tables, or what?
1297
April 23, 2012 08:10AM
1535
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.