• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

Best Practice: DB Lookup or Web Service?

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
namedpipes
Asked:
namedpipes
1 Solution
 
jlachCommented:
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
 
namedpipesAuthor Commented:
Sorry.. fell asleep at the wheel... Thanks for the input - I'll accept that answer now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now