[geeklog-devel] Draft of schema for GL2

[Tony Bibbs]

(sigh) it's attached.

Tony Bibbs wrote:


> 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

>>

>>

>>  

>>

>

> _______________________________________________

> geeklog-devel mailing list

> geeklog-devel at lists.geeklog.net

> http://lists.geeklog.net/listinfo/geeklog-devel



-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: create.sql
Url: <http://eight.pairlist.net/pipermail/geeklog-devel/attachments/20041217/5e1867fd/attachment.ksh>