Page 1 of 1

one domain + multiple blogs - how to organize sql?

Posted: Wed Jul 20, 2005 4:54 am
by gwilsonmail
with a single domain and multiple blogs is it better to

[1] have a single sql database and change the table prefix to identify each blog

[2] have a seperate sql database for each blog?

Re: one domain + multiple blogs - how to organize sql?

Posted: Wed Jul 20, 2005 11:14 am
by garvinhicking
It is better to have separate SQL databases. This way your database system can better layout the needed files and not crowd a single database too much.

It is then also much easier to backup specific blogs instead of having only a full backup for everything.

Regards,
garvin

Posted: Wed Jul 20, 2005 2:48 pm
by gwilsonmail
thanks