Home > programming > How to optimize slow website/ slow database?

How to optimize slow website/ slow database?


How to optimize slow website/ slow database?

Problems like No4 are very popular. These are testing your problem solving
skill, troubleshooting skill and past experience.

Mostly it is not expected to have perfect answer for these problems. Most
likely how you troubleshoot these problems. For example, for application
being slow:
– checking what has changed (data volume, code, hardware, database?)
– adding metrics collection/profiling [to figure out which part is taking
most of the time]
– adding monitoring [when it is slow, can you trigger some alarm to take
snapshot of the system for future analysis? Can you add some code to send
email/page to get immediate attention]
– review design/architecture/database for optimizations and improvments
– if you figured out which part is slow, how do you address that. what are
the possible senarios?
= SQL/DB related? improve SQL? SQL plan? Index? DB tricks?
= Memory, CPU, I/O,network throttled? how to improve?
= Parallelize? Algorithm optimization? etc etc.

skill, troubleshooting skill and past experience.

= Memory, CPU, I/O,network throttled? how to improve?
= Parallelize? Algorithm optimization? etc etc.”

Advertisements
Categories: programming
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: