Safe number of wordpress blogs on same database with different prefix?
 

Elleventy, numpty nine

but then im not an expert...

I would like to know this so here's a *BuMp!*

Of course it may vary much, but lets say each blog get about ~500 unique visitors/day.

wouldnt rec more than one if you have traffic

i run 10-15 per db tops. make sure you're running wp-cache though

Why not 100 blogs or more on 1 database?

Just use Blog Organizer
and dump wordpress.

Do you really want to have to update a shit load of WP blogs everytime a new security patch comes out? With BO you have one central admin and can run as many blogs as you can manage on one sever and then run more other other servers or at hosted blog sites.

WP is a waste of time IMO..

That doesn't answer his fucking question, spammer.

Technically there really isn't a maximum number of tables you can have per database. There is, but it's so ridiculously large that most people will never reach it. Performance-wise, you won't see any difference whether you have 1 blog per db or 100. I would recommend splitting them up just for the sake of organization.

Simple answer actually. Every mysql table is a file which has two more additional files (index file, data, etc). Usual wordpress installation has around 10 tables which is 30 files (depends on wordpress version).

Every time when surfer clicks something, your system has to find a table which is in a file and it takes some time. If there are a lot of files, it takes a longer time to enumerate all the files and find a table you need. So if you have thousands of files in a folder it can take several seconds to open your file.

I had a client who had 300,000 files in a folder and opening just one file for writing took around 25 seconds. So optimal limit should be around 300-350 wordpress installations in one database which is 1000 files in a folder. So you can be sure that everything works ok and it is also pretty enough for everyone.

Nice thread, I have been wondering this too. Thanks!