Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite performance tips » UltraLite benchmark tips » Methodology


The preparation phase

The preparation phase allows you to get your database and application in a state where they can be successful benchmark candidates, and to determine what goals you hope to achieve from your tests. Do the following:

  1. Complete the logical design of the database.

    Ensure you have:

    • Created and populated tables with representative data.

    • Created indexes to retrieve data in those tables more effectively.

  2. Prepare the physical deployment environment of both the database and application. The deployment environment must accurately represent the final production environment: that is, the lab and production environments should share the same memory and disk configurations on the same platform/device type.

  3. Ensure you have reached a stable point in your application programming phase. Remember you are looking for performance optimizations not defects; however, the latter may also be revealed as a result of testing.

    All database queries should access and return as much data as required. If the production environment requires sorting of data, ensure queries include this data as well. Otherwise, the application cannot accurately test representative memory requirements.

  4. Deploy a copy of the database and application to the final disk location.

  5. Decide what element of the database performance you want to check and potentially tune.

You can now run benchmark tests against your database and application.

 See also