I have a dedicated server with many wordpress blogs. My host provides for unlimited mysql databases. As such, in the past I'd been creating a new mysql database for each WordPress blog.
Now I'm wondering, completely from a performance perspective, whether it would be faster/wiser to use a single mysql database with different table prefixes or to continue using seperate mysql databases per wordpress install. Does having many mysql databases slow down the server at all?
I've searched through the forums to try to find this answer, but there does not seem to be anything that addresses how multiple or single mysql databases affects speed of wp-admin and wordpress sites in general.
Any help anyone can provide would be greatly appreciated!
Thanks in advance!
Emily from How to Blog