Zolf
asked on
network setup
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.
ASKER
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
">>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..
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..
ASKER
>>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
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 :)
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 :)
ASKER
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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..