Our application was running fine last month but now it is running slow. What is happening?
There could be a variety of causes. The most effective method to prevent a performance issue is to analyze each and every SQL statement in the application using a utility that is currently available called “explain.” By using “explain” in a development environment with enough test data, the poorly performing SQL statement can be identified. Explain will identify if a SQL statement may need to be rewritten, if an index isn’t being used properly, or if an index isn’t being used at all. Once the problem is correctly identified, several possible solutions are available. Analyzing the application code in development prevents reactive solutions from occurring in production. Please contact us for more information on “explain” for each of the database management systems we administer and we will be happy to provide more information on what is available for you and your environment.
Related Questions
- Every time I switch from another application to beaTunes, I see the blue spinning ball and beaTunes is slow. Whats happening?
- I am suddenly seeing java.lang.ClassMismatchError in my RMI application that was previously running fine. Why?
- I am suddenly seeing java.lang.ClassMismatchError in my RMI application that was previously running fine. Why?
- Our application was running fine last month but now it is running slow. What is happening?
- Agilian is running slow on Linux. Why is this happening?
- Agilian is running slow on Linux. Why is this happening?
