Connecting Tech Pros Worldwide Help | Site Map

large database

Newbie
 
Join Date: Aug 2008
Posts: 3
#1: Aug 31 '08
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
Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 292
#2: Aug 31 '08

re: large database


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.
Reply