[geeklog-devel] Draft of schema for GL2
tony at tonybibbs.com
Fri Dec 17 16:35:08 EST 2004
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
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.
>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 ;-)
More information about the geeklog-devel