[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Max Tables In A Database
From:       Stephen Johnson <stephen () la2nite ! com>
Date:       2000-09-29 23:12:31
[Download RAW message or body]

OK well, if Phorum requires 3 tables per message board then that is
probably not the product that you want to be using for your 1500 message
boards.  I have a message board dB set up that will allow for an unlimited
number of boards with only 3 forum tables (forum, forum_type, and message)
and 2 user tables (user, user_profile) and then I added one more table for
moderation and security (fuser_access).  Those 6 tables manage, currently
30 message boards on a http://www.la2nite.com and 10 on
http://www.ny2nite.com (oh yeah it allows for multiple websites as well,
obviously) 

The point is that message boards are easy to design and program.  so why
use a product that requires so much over head? 

Stephen Johnson 
stephen@la2nite.com 


On Fri, 29 Sep 2000, Peter Beckman wrote:

> Ok.  Using Phorum.  Want to have multiple (like 1500) chat
> rooms/message boards.  Phorum uses 3 tables per message board.  
> 
> So I'm reading the performance stuff on MYSQL.com in the
> documentation, and its seems that performance will be degraded
> somewhat with so many files (like 4500+ and growing) in a given
> directory.
> 
> This is on FreeBSD 4.1, mysql 3.22.32-log.  Phorum is a php- and
> mysql-based message board.  See it here:  www.phorum.org
> 
> Suggestions?  Thoughts?  Warnings?  These message boards will be used
> a good amount, as they'll be on a site that gets 500,000 page views a
> day.  Some of the 1500 will have very little data, some will have a
> WHOLE LOT.  
> 
> Thanks
> Peter
> ---------------------------------------------------------------------------
> Peter Beckman            Systems Engineer, Fairfax Cable Access Corporation
> beckman@purplecow.com                             http://www.purplecow.com/
> ---------------------------------------------------------------------------
> 
> 
> -- 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/documentation/manual.php" before
> posting. To request this thread, e-mail mysql-thread52049@lists.mysql.com
> 
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-stephen=la2nite.com@lists.mysql.com>
> 
> If you have a broken mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
>     http://lists.mysql.com/php/unsubscribe.php
> 
> 


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php" before
posting. To request this thread, e-mail mysql-thread52057@lists.mysql.com

To unsubscribe, send a message to:
    <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php

[prev in list] [next in list] [prev in thread] [next in thread]