Welcome to WebmasterWorld Guest from 54.145.44.134

Forum Moderators: open

Message Too Old, No Replies

Need some more understanding of databases

what they can handle

     

Matrixster

7:14 am on Dec 28, 2005 (gmt 0)

10+ Year Member



I need some more understanding of databases.

I am in development of a website that will hold many separate phpbb installs and am planning on having all them share the same user table, and I am planning on putting all installs in the same database for this purpose (unless this will make my database load too much).

What if my site gets too big and things get slow? How do you know if your database is too big? Would it be more efficient if I put each phpbb install in its own database? Or is this something I can worry about once/if I do get big.

Help is much appreciated

txbakers

10:25 pm on Dec 28, 2005 (gmt 0)

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



a database such as mySQL can hold millions of records before it starts to slow, so I wouldn't worry. Phpbb takes many tables, so it you want multiple bulliten boards, you will need separate databses. (unless you jimmy the code to write to different tables - very advanced)

Matrixster

3:00 am on Dec 29, 2005 (gmt 0)

10+ Year Member



"phpbb takes many tables, so it you want multiple bulliten boards, you will need separate databses. (unless you jimmy the code to write to different tables - very advanced) "

Well that can be solved with different table prefixes for each board if they are in same database (I believe)

txbakers

3:41 am on Dec 29, 2005 (gmt 0)

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Yes it can, but you'll have to do that yourself. it's rather advanced.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month