March 29, 2009 at 11:13 pm
Hi,
I have a Swing Application which runs good when the database server is in LAN. However, when the DB Server is situated on remote site and I access it over WAN, application is terribly slow.
What can we do to increase the performance over WAN?
Thanks,
TNV
March 30, 2009 at 2:25 am
Poor performance is due to data tranfer between SQL Server and client application. There's no simple solution: in some way you will have to change your application or your system architecture.
You could code your app to cut down data trasferred between client and server, but it isn't always easy.
Another thing you could do is publishing the app in some sort of container, such as Citrix, but this involves a big change in the system infrastructure.
Last but not least, you could code your app in web (jsp / servlet / jsf / myfaces ... whatever you like).
Regards
Gianluca
-- Gianluca Sartori
March 30, 2009 at 1:09 pm
Have a look to the queries of your application:
* Does it select objects from same type one by one?
* Does it use server side cursors?
* Does it select too much data (SELECT *)?
Greets
Flo
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply