DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Perth Western Australia

    Lightbulb Database Applications - General

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

  2. #2
    Join Date
    Dec 2003
    San Diego
    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,
    Michael Sanchez
    Managing Technical Editor
    Forum Moderator

Similar Threads

  1. XML files vs Database
    By Mansoor in forum XML
    Replies: 8
    Last Post: 08-23-2002, 04:35 PM
  2. MS-Access Error - Obsolet Database Format !
    By Makl. Lemmertz in forum VB Classic
    Replies: 2
    Last Post: 10-29-2001, 11:12 AM
  3. How to analyze corrupted Access databases
    By Raffaele in forum VB Classic
    Replies: 15
    Last Post: 06-27-2001, 09:28 AM
  4. "Suspected" DataBase - problem with Log file
    By Nirit Touboul in forum Database
    Replies: 0
    Last Post: 04-01-2001, 07:37 AM
  5. SQL in CT
    By Purple girl in forum Database
    Replies: 0
    Last Post: 07-05-2000, 12:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.