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? What are the names of the files that you downloaded? What is the product version and release number? What is the name and version of the client operating system? Provide the output of uname -a for unix and linux clients. Problem Description Has this problem always existed? If this problem is new, describe any changes to the database, database client, network and machines in this architecture. Is this problem associated with heavy load. Provide Data Source Name Connection Parameters. Environment What are your database server's kernel tuning parameters? What is your database server's patch level? Problem Isolation Is this problem specific to one client machine? Is this problem specific to one client application? Do other ODBC drivers outperform OpenLink ODBC drivers? Is this a LAN/MAN/WAN? Can you quantify the amount of data that is being returned? What are the data types of the data being returned? Have you checked the Defer Fetching of Long Data checkbox? (For binary data only) Do you know what cursor modality your application employs? Set your Data Source's Rowbuffer Size to 1. Test. Set your Rowbuffer Size to 99. Test. Do you see any difference in performance? Other Considerations OpenLink's latest drivers have faster communications layers. If you have an older driver, can you upgrade? * Performance problems may stem from the way you have structured your tables. Can you provide a table schema for a problem table?