Solved

Best Practice: DB Lookup or Web Service?

Posted on 2003-10-26
2
183 Views
Last Modified: 2010-04-16
My application will be given an employee number. It has to query a database for the username and group memberships matching this employee. I have to use Access or MS SQL. I cannot use ADSI. Multiple applications will eventually query similar info from the same database. There will be an initial load of 5000 - 10000 queries per day. (looking at the current logged in user is cheating)

1) I can put the database inquiry direct in the application

or

2) I can design a web service to return the same information, and put the database inquiry there.

My thought is the fact that other applications will probably access the same info, better to use the service. Plus it seems cool.

Thoughts on the subject?
0
Comment
Question by:namedpipes
[X]
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
2 Comments
 
LVL 1

Accepted Solution

by:
jlach earned 50 total points
ID: 9630282
i agree with your thoughts.. we do it differently here at my job.. all our apps query a central db, and i've also thought it to be bad ... i, in my opinion, think its better to keep all your sql in one central place (the server) and use remoting to execute methods on the server, and read the return value.. that way, if you need to change sql, you have to update the server, and not every client out on the market.. plus everything is centralized.. you dont need to worry about exposing the database to the outside world or anything like that... like i've said, using a central server seems like a better practice to me
0
 
LVL 2

Author Comment

by:namedpipes
ID: 9877168
Sorry.. fell asleep at the wheel... Thanks for the input - I'll accept that answer now.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

729 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