Troubleshooting Worksheet -- Multi-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 Operating System containing your Multi-Tier client components? Provide the output of uname -a for Linux and other Unix-like machines. What is the name and version of the Operating System containing your Multi-Tier server components? Provide the output of uname -a for Linux and other Unix-like machines. Problem Description Has this problem always existed? If this problem is new, describe any changes to the database, network, and machines in this architecture. Is this problem associated with heavy load? Provide Data Source Name Connection Parameters. Server Environment What are your database server's kernel tuning parameters? What is your database server's patch level? Did you install your server components on the database native server? If you answered yes to the above, could you install your server components on a machine that contains the database native client? This could be the same machine or a gateway. (Routing connections through the database native client may speed performance in problem environments.) What is your database native client version? Are you establishing a connection to Progress? Is it running in sockets or shared memory? Problem Isolation Is the 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, or VPN? 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 the 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 Single-Tier drivers outperform Multi-Tier drivers. Could you switch? 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? CategoryWebSite CategorySupport CategoryWorksheet CategoryUDA