large database

[kompallikedar]

pl tell me which is the best out of the following
I have got an application of php and postgresql and same has to be implemented as central server and it is connected to various remote locations

1. Creation of number of database seperately
2. creation of large database

thanking you

[rski]

In my opinion one database is better solution, but of course you should design it well. The main problems with databases
1.your application should make more than one connection, and it probably will take some time,
2.what if you want to merge data from different databases, will you use dblink module, or you application will do it for you (i think db should do it for you)

This is my opinion.