Welcome to WebmasterWorld Guest from 50.17.5.36

Forum Moderators: open

Message Too Old, No Replies

Need some more understanding of databases

what they can handle

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

Junior Member

10+ Year Member

joined:Apr 5, 2005
posts:89
votes: 0


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

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

Senior Member

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

joined:Sept 1, 2001
posts:4392
votes: 0


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)
3:00 am on Dec 29, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 5, 2005
posts:89
votes: 0


"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)

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

Senior Member

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

joined:Sept 1, 2001
posts:4392
votes: 0


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