rhunt
Well Known Member
Hello List,
I am trying to complete a tuning exercise on a new AS/400 with some performance issues.
Does anyone have a preference on the following options with regard to AS/400 datasources? Do you treat the Do Not Translate ODBC differently? Did you select these options based on best practice, or do you have specific reason to do so? Lastly, if anyone has any undocumented ODBC tricks that speeds things up, I would love to hear them…thanks.
-Enable Lazy Close Support
-Enable Data Compression
-Cache Package Locally
Thanks in advance.
Ryan Hunt
I am trying to complete a tuning exercise on a new AS/400 with some performance issues.
Does anyone have a preference on the following options with regard to AS/400 datasources? Do you treat the Do Not Translate ODBC differently? Did you select these options based on best practice, or do you have specific reason to do so? Lastly, if anyone has any undocumented ODBC tricks that speeds things up, I would love to hear them…thanks.
-Enable Lazy Close Support
-Enable Data Compression
-Cache Package Locally
Thanks in advance.
Ryan Hunt