8 replies to this topic

[l3lueMage]

I have a question about Tables etc. and database design.

Do you create a different table for each 'page' that is different.

For example on Pixel2life does the Contact page have a different table then the About page in the database? And if so is it better to put these in completely different databases or just put them in diff tables but in the same database?

[pirateXcore]

The About page would run off of a different table than the Contact one.
You would want them in the same database.
It's good to break up your stuff into small chunks, it's a lot nicer on the server.
It will also load faster for the user.

[l3lueMage]

Okay, and is it better to have like forums in a diff db as the main site, and ya ...like stuff related in 1 database and other stuff in other db ? o;

[Samy]

having both in the same db makes your script run faster

[Bug]

And, theoretically speaking (because I've never done this before), having the forum and the main site in the same db is more efficient for connecting the user information with the main site?

[Samy]

better to use 2 dbs for forum and main site

[Bug]

But why is that? How does having two dbs work more efficiently?

[hazard]

^ More organized imo.

[Wildhoney]

A lot more organised, and for the speed increase being as negligible as it is, as MySQL connect statements are exceptionally fast, 2 databases is the way forward.