MySQL Forums
Forum List  »  Optimizer & Parser

Re: 1000 Columns, 1000 Tables, or what?
Posted by: Rick James
Date: April 26, 2012 07:59AM

> didn't decide yet if it should become ... another CMS
How many dozen CMSs are out there now?
Have you checked more than just WP -- to see if some other one has the features you want?

NIH* -- It is a lot of fun, but it is a lot of wasted effort. At least you are considering starting with an existing product.

A hierarchy is pretty simple to implement -- just a parent_id that self-joins to the same table. Be sure to have separate tables for the "thread as a whole" versus "the blog entries". (One product tried to put those in the same table, with 'bad' results.)


*NIH is the TLA for "Not Invented Here", the thing the lures programmers into doing more work than they ought to. (And enjoying it.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: 1000 Columns, 1000 Tables, or what?
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.