network setup

zolf
zolf used Ask the Experts™
on

hello there,

i have a java application which uses swing,msserver 2003 and mssql 2005 db. now it is working on local lan and it is working with no complains.now i want remote users to access the software from different branches.how can i achieve it without compromising on the efficiency of the speed of the application.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
How are you accessing the application right now?? Is it via a website?? If so, just let the users connect to this website (either using VPN or SSL and make sure to only let that traffic enter the network) and your good to go...

If it is a client they are using, it depends heavily on your network setup.. What ports are yiou using to work with the application, the standard SQL port?? Also, how large is the database?? If so, i'd say just test and see how the application performs when remote users work with it.. There is no way of telliong how heavily bandwidth will be trhottled..

Author

Commented:

in the local network the user enters a ip 192.168.0.1 which shows a link pointing to the java application.then the user uses the application.the server i am using is apache server.

>>and make sure to only let that traffic enter the network
can you please tell m emore about this

>>If it is a client they are using, it depends heavily on your network setup..
yes the remote client downloads the java application via JNLP then staarts using the application.

>> What ports are yiou using to work with the application, the standard SQL port??
using default port

>>Also, how large is the database??
it is around 10 MB and increasing day by day

>> If so, i'd say just test and see how the application performs when remote users work with it..
it is very slow at present

>>There is no way of telliong how heavily bandwidth will be trhottled..
how can i test this

Commented:
">>and make sure to only let that traffic enter the network
can you please tell m emore about this"
Ok, were do we start.. How do your extarnal users contact your network?? are they able to contact it at all at this point?? Do you have a firewall on the network?? You said the users install the application, that means port 1433 needs to be open for those specified external users, this is the default SQL port.. I'd suggest using any kind of VPN solution for them to access your network..

">>If it is a client they are using, it depends heavily on your network setup..
yes the remote client downloads the java application via JNLP then staarts using the application."
However you do it, it will generate heavy amounts of data because the client will ask SQL to give it the data, that will all be send over the line you have.


>>Also, how large is the database??
it is around 10 MB and increasing day by day""
Ok, so it's a rather small database..


">> If so, i'd say just test and see how the application performs when remote users work with it..
it is very slow at present"
For local users or for external users?? If local users are expierincing slow performance than remote users will even more.. I'd say fierst get it working fast enough locally, then start jusing it externally.


">>There is no way of telliong how heavily bandwidth will be trhottled..
how can i test this"
Use a tool like MRTG to test how much data is being send over the line when using the app and when not using the app..
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:

>>Ok, were do we start.. How do your extarnal users contact your network??

some use ADSL with 256kb/s some use dialup modem

>>are they able to contact it at all at this point??

yes,but at one branch i have two users who need to access the server,but both cannot access together.the users with dialup connection is very slow compared to the remote branch where they have adsl


>> Do you have a firewall on the network??

only the microsoft default server

 You said the users install the application, that means port 1433 needs to be open for those specified external users, this is the default SQL port.. I'd suggest using any kind of VPN solution for them to access your network..

at present the remote user with adsl use microsft vpn to connect to the server and then use Remote desktop becasue this way their speed is faster

>>However you do it, it will generate heavy amounts of data because the client will ask SQL to give it >>the data, that will all be send over the line you have.
how can i solve this problem other then software

>>For local users or for external users?? If local users are expierincing slow performance than remote >>users will even more.. I'd say fierst get it working fast enough locally, then start jusing it externally.

the local users are not expirencing any slow performance,infact it is quite good

>>Use a tool like MRTG to test how much data is being send over the line when using the app and when >>not using the app..
can you please tell me some free tools

Commented:
So it means you would like your home users to access the application..
You could either rebuild the application so they can contact a website that than let the webserver contact the SQL server fro transferring the data.

It's not very strange that a dial up connection is that much slower than ADSL..  

"at present the remote user with adsl use microsft vpn to connect to the server and then use Remote desktop becasue this way their speed is faster"
I'd say make sure all users work like this, either using anyu kind of terminal server or let them connect to their own machine at the office.. Rebuilding the app is pretty difficult i think and using this option will make it that much better for them. Also, there is no other way than making the app using a website instead of a java app..


">>Use a tool like MRTG to test how much data is being send over the line when using the app and when >>not using the app..
can you please tell me some free tools"

MRTG is a free tool :)

Author

Commented:

thanks a lot for your feedback.
you mentioned
You could either rebuild the application so they can contact a website that than let the webserver contact the SQL server fro transferring the data.

what is the different from my application.can you please explain
Commented:
As you tell me now you have a JAvaapplication. Users download this to their machine, am i right?? They open the application on their machine and this application is going to contact the SQL server for it's data, hope i'm still right here.. :) This means all SQL data will be pushged over the line to your client.. The server will be receving data requests from all local machines.

If you rebuild the application to a web application, all users will ne accessing the web server (which is build for these kinds of things) and the webserver will be the only server reqeusting info from your SQL server.. Not only is it much more secure, it is also a lot less restraining to your network environment..

I am making some assumptions here so i just might be wrong..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial