[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
>
>
>  
>