[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