Multiple Databases or Single Database

[JoyceBabu]

Can anyone plz tell me the advantages and disadvantages of using multiple databases / single database for all tables.

I have a site with more than a 100 tables. Current all the tables are in a single database, so that I can access it with a single Database Wrapper Object (PDO). Should I split it into multiple databases? Will it affect the speed?

[code green]

Sounds to me that you have a collection of 100 flat files rather than a database.
I doubt you would be asking the question if it was a true database design.

[JoyceBabu]

Sounds to me that you have a collection of 100 flat files rather than a database.
I doubt you would be asking the question if it was a true database design.

I am not sure why you said that. My experience with database is limited.

[code green]

Well a hundred tables of what?
If they are all an integral part of the database, then splitting them is not an option.
If however they are storing similar information,
and I suspect they are growing in number,
then you simply have a collection of tables

[Atli]

How you split up your tables is more of a design issue than anything else.

For most projects, putting all the tables into a single database is fine. It's not unless you are working on some massive project that might need some larger scale organization that you should start considering splitting it up.