Performance & Tuning Services

A common scenario is one, whereby a new system is developed in a test environment and performs satisfactorily, but when the system has been in production for a period of time, and as data volumes increase, the application gradually suffers from performance problems, until eventually the application is no longer useable. 

In general with most database systems, if the SQL statements running against the database are inefficient, then tuning the database or operating system can only yield a certain improvement in performance levels. Dramatic improvements in application performance can be achieved by tuning the SQL/code.

Prosoft Solutions can provide Application/SQL tuning services during the following stages for a project.  

1) Prior to Development.

Instruct developers in the DO'S/DON'TS of writing efficient SQL/code.

2) During Development.

We can QA your code and test your application against a database with data volumes similar to production volumes and identify any potential bottlenecks.

There are some Oracle tools and a number of third party products which can  rapidly identify any offending SQL statements. Once the SQL statement or query/s causing the bottleneck has been identified, it is generally possible to modify the SQL statement to run more efficiently.

3) Production System

It is not always possible to tune a application during the development stages as quality production data is not always available and difficult or impossible to simulate.

The behaviour of the oracle query optimiser can also change over time depending upon the volume and type of data and therefore an SQL statement which was efficient at one stage can become inefficient over a period of time.

Tuning is a iterative process and should be carried out on a periodic basis.

Back