Java and Database
I've a database for an insurance company . very much traffic at peak times. It has two servers ,one located at UK and annother at India. The client machine is installed at india .and from there they access both servers. At peak times the perfomance is very bad[actually it takes more than 20 mts to get query result].All database design and other things are perfect. The problem is in client application design ,i think. Sir can we use the singleton design approach on this application? again the data traffic is very high at peak time.Is it possible to apply singleton design on such high traffic-system?
please give me your valuable suggetion on this matter. Would anyone help me to redesign the code using singleton approch?