[geeklog-devel] Draft of schema for GL2

Tony Bibbs tony at tonybibbs.com
Fri Dec 17 16:39:41 EST 2004


(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: <https://pairlist8.pair.net/pipermail/geeklog-devel/attachments/20041217/5e1867fd/attachment.ksh>


More information about the geeklog-devel mailing list