|
|
|
In your new installation, you should test your applications, query performance, and system administrator procedures.
|
|
|
As changes are made to the application for Ingres compatibility, bring the changes over to the development Ingres installation and test your applications according to your test plan.
When testing, use data that is as close to live data as possible. Performance-critical functions should be tested against production data volumes.
|
|
|
Include performance testing in your test plan. Changes to the query optimizer can cause queries to perform differently from your original Ingres version.
Typically, queries are faster, but in some cases, may be slower. This is likely when a query has been tuned to work well with a peculiarity of the old-version query optimizer. If you notice performance problems, use the set qep command or the QEP display of Visual DBA. For more information on the use of query plans and optimizer statistics, see the Database Administrator Guide.
|
|
|
You should test your system administration procedures.
Test the Ingres installation when it is busy by pulling the power plug or issuing a system command to crash the servers. Make sure that recovery occurs correctly.
Do at least one rollforwarddb of the most important databases and make sure it works in your environment.