473,812 Members | 2,859 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Architecture Decisions Regarding Common DB Access, Remoting, and Performance

JTS
I need to create three ASP.NET applications - each one will run on a
different production server. Each application does basically the same thing
with respect to data access; the apps differ primarily in presentation and
audience. Each app will need to interact with a SQL Server database that is
running on its own server. All servers will initially be on the same subnet,
however there is no guarantee that they will remain on the same subnet in
the future (the SQL Server may go behind an its own firewall). Just
considering my architecture options...

Is this scenario a no-brainer for separating out the data access logic to
its own assembly? If so, is .NET Remoting the obvious choice for
communication (given the close proximity of the boxes)? What about the
future firewall for the SQL Server - how would that impact the design, and
should I design for that up front? What about performance considerations. Am
I correct in thinking that implementing a Web Service (strictly for data
access services from behind the firewall) in this scenario would only serve
to hurt performance and create bigger headaches for data security on the
wire in (comparison to implementing data services via .NET Remoting)?

Any thoughts on any aspect of these factors is greatly appreciated
Nov 18 '05 #1
0 960

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
4651
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet 4 to Service Pack 7 2) Set Subdatasheet Name to from 3) Shortened the file name of the .MDB file 4) Made sure the Track name AutoCorrect info is off
9
2889
by: Rob | last post by:
Scenario: O/S: Win XP Professional Back-end: Access 2002 on network server I have an Access 97 application, in production on our network, that takes appoximately 5 minutes to process monthly data. I find this tolerable. The Access 2002 test version, on the network, takes approximately 50
2
1378
by: Janus Knudsen | last post by:
Hello Im collecting ideas for a piece of software I've in mind. I need to create an application which can be started with some parameters, the application have to be started in many instances and on many servers. Every instance has a special job to fullfill, think of the instances as small robots - a robot farm or something like that. Every robot should be able to tell for instance when its idle, when its running etc..
2
2496
by: Dave Griffin | last post by:
We're developing an client/server application where the client exports well known services using remoting (using the TCP default formatter) and the clients (usually there is only 1) attaches to these remoted classes and dequeues data from a threadsafe queue. Functionally it works great, but the amount of actual throughput we can get seems CPU limited. That is sending large amounts of data such as serializable classes containing 5000 - 40000...
2
7188
by: Craig Santoli | last post by:
"... to ASPNet as attempted from C:\WINNT\System32\WBEM\WinMgmt.exe." This error keeps appearing in the Windows 2000 Server Event Viewer. Any ideas on what's causing this or how to prevent it? Thanks, Craig Santoli
0
958
by: RattleMind | last post by:
1)There is a slowness when we using Dot NEt remoting 2)we wanted to know by changing the configuration files or iis setting could we improve (OS is Windows 2003,IIS 6) the NEt Remoting performance 3)we are using Dot NET remoting on IIS using Binary Stream over http . What we have seen is even though we modified the webconfig file setting of "clientconnection" from 2 to 200, however the remoting server is always processing 2 request at a...
2
1697
by: Ryan | last post by:
My apologies if this is not the forum to post questions regarding .NET Remoting, but I figured WebServices would be the most appropriate forum of the bunch. We're currently completely re-arching some software (currently it's essentially a single tier app - a giant meat ball - we're turning it into an n-tier architecture; gotta love ex-employees). One of the things we're looking at doing is using Remoting from the client to an appserver...
1
3200
by: frank.preiss | last post by:
Hi, I'm looking for help monitoring the communication of a client/server application. We are using the .Net default serialization/ deserialization with the binary formatter using .Net 2.0. I don't see any chance spying on what is going on during communication. We experience poor performance and I want to figure out why. I'd like to measure the throughput and amount of data and I'd like to figure out how much time is consumed by...
3
2579
by: aernst | last post by:
I found some helpful replies to someone's post regarding data base replication. I started approaching my problem pretty much the same way but need someone with way more knowledge than me to provide guidance. Basically I know very little about these things but want to learn so please bear with me. The symptoms: I created a very very small MS Access DB (first one - indicative of current knowledge level). It did what it was supposed to do,...
0
9734
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10663
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10138
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9217
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6897
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5704
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4357
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3881
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3029
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.