homepage Welcome to WebmasterWorld Guest from 54.163.91.250
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Need some more understanding of databases
what they can handle
Matrixster




msg:1580575
 7:14 am on Dec 28, 2005 (gmt 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

 

txbakers




msg:1580576
 10:25 pm on Dec 28, 2005 (gmt 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)

Matrixster




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

txbakers




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

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved