I have a question related to response time of a centralized vs. a
distributed database. Suppose I have a database made up of one record
type that is fairly simple, consisting of 20 or so data elements. Suppose
there are X records, where X is a large number, lets say 10*6. Suppose
I am concerned about the response time. If I had all records stored in
one database on a single computer, would the response time be better than having the database distributed among 10-20 computers on a wide area network. Assume that network traffic is not a problem and that I am using a modern relational database such as Oracle
7. I may also have thousands of users accessing the database.
Any help, either theoretical or operational would be appreciated.