Hello,

I want to optimize my database in mysql v 5.1.32.

Actually i host a web site that use my DB, and all of my table is in one Data base!

At first, is taht correct to to only one database? Or it's better to have more?


Thank's for your help!

Pascal_22

oui

until you need more than one database, use just one

if you are implementing different scripts like content management, e-commerce, etc., and they come with their own tables, then that might be a good reason to segregate the tables into different databases

size alone is not usually a good reason to have more than one database, because more than one introduces further complexities (e.g. single site signon)

Good, thak's for the comments.

If we talk about the maximun connexion allowed: is that a config for Apache or mysql ? or do we need to set up a maximum connexion for each Database in mysql??


Thank's

Pascal_22