Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Client/server architecture design

Posted on 1999-06-28
Medium Priority
Last Modified: 2013-11-20
Hi Experts,
I have to make an architecture desicion, any tips are welcome.

a) Accessing an MS Access-database on a NT-server directly through a DSN on the clients. (with ADO or DAO)

b) Writing a NT service application that gets requests from clients (through sockets) and uses ADO and DAO to do the searching and then returns the results back to the clients.

What are the consequences for performance, and do I have to use multithreading for option B?

(btw: most of the time, the database is only used to retrieve either a complete table or to find one specific record)
Question by:MelissaC
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

Liu earned 200 total points
ID: 1308170
Option a) is a lot easier to implement than b). If you have only a few weeks to do it, a) is probably a better solution.  

Option b) is more complicated and very hard to debug, but gives you more flexibility.  You can hide database details, add extra business logic at the middle layer, etc.  You don't have to use multithreading for option b).  But if the users are retrieving whole tables, then using multithreading is necessary because in single thread mode, while a whole table is being retrieved by one user, other users have to wait.

I am not clear about performance.  It depends on many factors.  My guess is if there are a lot of simultineous users, b) will perform better.  

Remember it will take a lot longer to implement b).

Author Comment

ID: 1308171

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: Hints for the grid button.  Nested classes, templated collections.  Squash that darned bug! Continuing from the sixth article about sudoku.   Open the project in visual studio. First we will finish with the SUD_SETVALUE messa…
If you use Adobe Reader X it is possible you can't open OLE PDF documents in the standard. The reason is the 'save box mode' in adobe reader X. Many people think the protected Mode of adobe reader x is only to stop the write access. But this fe…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question