Large Database Tables

  • Thread starter Thread starter Mythran
  • Start date Start date
M

Mythran

I have several "common" tables in a database. This database will be used by any
application that would otherwise duplicate this same data (employee information,
department information, et cetera). We are going to create a webservice which
allows all of our other applications to get the information they require. What
we are wonderin' is if an application needs custom data (a select that we don't
offer through stored procedures), and they need to do an inner join on this data,
could they "easily" do it if they get all of the rows in the table(s) that they
need?

Also, is there a "better" way?

Thanks,
Mythran
 
It depends on how the server is exposed. If the server is only visible to
the IIS server behind the firewall (it should be), then clients won't be
able to do direct queries on it without poking holes in the firewall. If
you're working with a LAN on a Windows domain you will be able to access the
server with any kind of query. If this is the case the rationale to use a
Web Service is pretty thin.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
To tell you the truth, the exact solution depends highly upon your exact
situation. But you could use a mix of the following -

a) If this is a high demand webservice, consider caching the dataset in
enterpriseservices
b) Pass in innerjoin criteria, but try and avoid webservice and dataset mix.
c) Setup a relation on the cached dataset, setup a relation, do a get
childrows, and return the childrows collection as a wrapped business object
d) Consider using dataview for the innerjoin purposes.

Again I might be missing something exact to your situation, but above should
be good pointers.

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik
 
Back
Top