Ask the Expert

High traffic and bad performance at peak times

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 reply.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: