• Topic
  • Discussion
  • SupportWeb.WorksheetMTperformance(Last) -- Owiki? , 2016-08-19 14:59:38 Edit owiki 2016-08-19 10:59:38

    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


    Referenced by...