Database Applications - General

[milton]

Hi all
I have a general enquiry regarding database applications.
Over the past few years I have written a couple of small database applications to meet clients specifications. These are basicly a database installed on a server and the application (with multiuser support)to access the data on each client machine (workstation). This seems to be a simple implemenation but works well (with good coding).
Recently I have seen a few Server/Client database application (example code only). At first glimpse this seems to be a better way of implementing multiuser database on a network .. I'm still learning more about it !!!!!
My question is is one method better than the other, what are the pros and cons of each method? I would imgine this topic would be extensive to discuss in detail .. hence my enquiry being GENERAL
any feedback on this would be appreciated.
Many thanks for your time ..
Regards
Milton

[msanchez]

If I understand your application architecture correctly, thenI would suggest doing the opposite as you found in your searches.

It is always better to have all your data centralized in a single data store with some sort of RDBMS such as SQL Server or Oracle, or even the latest version of MySQL. It's better for data integrity and better performance.

You are right, this conversation could go on at length, so hopefully others will start to add to this discussion.

Good luck,