Q

High traffic and bad performance at peak times

Our database has very much traffic at peak times. It has two servers, one located in the U.K. and another in India. The client machine is installed in India. From there they access both servers. At peak times the perfomance is very bad. All database design and other things are perfect. The problem is in the client application design, I think. Can we use the Singleton design approach on this application?

The database is for an insurance company. There is very much traffic at peak times. It has two servers, one located in the U.K. and another in India. The client machine is installed in India. From there they access both servers. At peak times the perfomance is very bad. All database design and other things are perfect. The problem is in the client application design, I think. Can we use the Singleton design approach on this application?

I'm assgned to suggest a redesign strategy for this one. If you are familiar with this kind of thing please re

ply.

You should confirm that the database is not the bottleneck. The best way to do so is to trace a typical session. If the total elapsed time for database service is small compared to the total elapsed time for the operation, then the bottleneck is not in the database and you'll have to inspect other application or network components.
This was first published in November 2005

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close