one domain + multiple blogs - how to organize sql?

[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?

[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

[gwilsonmail]

thanks