[geeklog-devel] Draft of schema for GL2

[Tony Bibbs]

Ok, I've attached the latest schema.

My next question is do we need to worry about the potential size of the 
gl2_item table from a performance view point?

I just did some preliminary counts on key tables for Iowa Outdoors and I 
would have in the neighborhood of 150,000 records in the item table.  So 
extrapolate that out to, say a Groklaw, I think you could get well into 
the millions of records.

I don't think it's the number of rows in the database that bothers me as 
much as doing the joins to all the plugin-specific one-to-one item 
tables to the main item table at the same time.

Someone with a real DBA mindset needs to make sure I'm not going off my 
rocker.

--Tony

Dirk Haun wrote:


>>>Do we want an association table between items and categories so items

>>>can be in multiple categories?

>>> 

>>>

>>>      

>>>

>>Good question. It gives more flexibility...a tad bit more complexity.  

>>Any objections?

>>    

>>

>

>If this would enable stories to be in multiple topics, blocks to be in

>multiple topics, and smililar constructs, then our users want it ...

>

>I have to admit I'm not quite sure what you're actually talking about here ;-)

>

>bye, Dirk

>

>

>  

>