newbie distributed arch.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vin - 23 Oct 2004 17:11 GMT

Hi and TIA,

My windows app has the the following structure:
Thin Business Entities (loaded with datareader on the DAL)
DAL using MS application block for SQL Server
Business Logic Layer

The Network:
5 Locations connected with VPN

The Problem:

The performance is unacceptable. 45 seconds to populate a grid that takes .5
seconds on the development machine.

Solution:

1)Use terminal services (Since part of my app is document management I need
to have the ability to download a MS Word Document or TIF to the client
Machine)

2)Web Services (Return My Bus. Entities or XML and construct the Entities
locally)

3).Net remoting - will this help?

4)Currently the app and the dll'sm are on the client- will changing the
physical location help?

5) I am writing another Presentation Layer - Web Based ASP.Net but having
trouble with the different screen resolutions and display of TIF's

Please help with some suggestions on direction and the plus/minus tradeoffs.

Thanks very much
vin

Reply to this Message

Sam Santiago - 30 Oct 2004 18:10 GMT

I would first try to determine why it is slower over VPN. I could be
simply that the VPN bandwidth is insufficient or the method your clients are
connecting to the VPN is to slow (via dialup for example). Determining the
cause of the slowness will help determine the best solution for you.
Assuming network bandwidth is the issue over VPN then I would vote for
Terminal Services first and then a web based UI if that's not possible.
Essentially, you need more information to make the right decision.

Thanks,

Sam

Signature

_______________________________
Sam Santiago
ssantiago@n0spam-SoftiTechture.com
http://www.SoftiTechture.com
_______________________________

> Hi and TIA,
>
[quoted text clipped - 32 lines]
> Thanks very much
> vin

Reply to this Message

vin - 30 Oct 2004 18:36 GMT

Sam,

Thank you for responding. The server has a fractionated T1 line and the
office i tested at has a dsl. Since the DAL is now on the client and the
database on the server, I wonder if the datareader I use to load my array of
entities in the DAL is making multiple round trips to the server? On a VPN
this would be very slow, of course.

So i was wondering if I could create my DAL as a remotable object on the
server and use TCP and binary formatting to return my serializable object
array? Do you think that would be helpful?

Terminal services are fine if needed. My issue there is that I will need to
figure out how to download a file(MS WORD Doc) from the server to the client
machine and upload it programmatically from my app which will be residing on
the terminal server. Any suggestions.

Thanks again. Greatly appreciated!
vin

> I would first try to determine why it is slower over VPN. I could be
> simply that the VPN bandwidth is insufficient or the method your clients are
[quoted text clipped - 47 lines]
> > Thanks very much
> > vin

Reply to this Message

Sam Santiago - 30 Oct 2004 19:17 GMT

If your DAL is on the client then that could be contributing to your
problem. Instead of datareaders on the client, perhaps it would be better
to use Datasets. Have a middle tier component access the DB and return a
Dataset to the client for use or create the object array in the middle tier
and return that to the client. You could use remoting, web services, or
serviced components to accomplish this. Have you checked out these links on
MSDN before:

Designing Data Tier Components and Passing Data Through Tiers
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/BOAG
ag.asp

Data Access Application Block
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab
-rm.asp

Designing the Components of an Application or Service
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/appa
rchch2.asp

Thanks,

Sam

Signature

_______________________________
Sam Santiago
ssantiago@n0spam-SoftiTechture.com
http://www.SoftiTechture.com
_______________________________

> Sam,
>
[quoted text clipped - 67 lines]
> > > Thanks very much
> > > vin

Reply to this Message

newbie distributed arch.

Free Magazines