---+ Troubleshooting Worksheet -- Single-Tier Driver, System Performance
    
  
Use this form to gather information which will help us better assist you.

---++ System Information

   * What product are you using?
%BR%%BR%
---
%BR%%BR%
   * What are the names of the files that you downloaded?
%BR%%BR%
---
%BR%%BR%
   * What is the product version and release number?
%BR%%BR%
---
%BR%%BR%
   * What is the name and version of the client operating system?
%BR%%BR%
---
%BR%%BR%
   * Provide the output of uname -a for unix and linux clients.
%BR%%BR%
---
%BR%%BR%


---++ Problem Description

   * Has this problem always existed?
%BR%%BR%
---
%BR%%BR%
   * If this problem is new, describe any changes to the database, database client, network and machines in this architecture.
%BR%%BR%
---
%BR%%BR%
   * Is this problem associated with heavy load.
%BR%%BR%
---
%BR%%BR%
   * Provide Data Source Name Connection Parameters.
%BR%%BR%
---
%BR%%BR%

---++ Environment 

   * What are your database server's kernel tuning parameters? 
%BR%%BR%
---
%BR%%BR%
   *  What is your database server's patch level? 
%BR%%BR%
---
%BR%%BR%


---++ Problem Isolation

   *  Is this problem specific to one client machine? 
%BR%%BR%
---
%BR%%BR%
   * Is this problem specific to one client application? 
%BR%%BR%
---
%BR%%BR%
   *  Do other ODBC drivers outperform OpenLink ODBC drivers? 
%BR%%BR%
---
%BR%%BR%
   *  Is this a LAN/MAN/WAN? 
%BR%%BR%
---
%BR%%BR%
   *  Can you quantify the amount of data that is being returned? 
%BR%%BR%
---
%BR%%BR%
   *  What are the data types of the data being returned? 
%BR%%BR%
---
%BR%%BR%
   *  Have you checked the Defer Fetching of Long Data checkbox? (For binary data only) 
%BR%%BR%
---
%BR%%BR%
   *  Do you know what cursor modality your application employs? 
%BR%%BR%
---
%BR%%BR%
   *  Set your Data Source's Rowbuffer Size to 1. Test. Set your Rowbuffer Size to 99. Test. Do you see any difference in performance? 
%BR%%BR%
---
%BR%%BR%


---++ Other Considerations

   *  OpenLink's latest drivers have faster communications layers. If you have an older driver, can you upgrade? 
%BR%%BR%
---
%BR%%BR%
    * Performance problems may stem from the way you have structured your tables. Can you provide a table schema for a problem table? 
%BR%%BR%
---
%BR%%BR%