Debra Waybright Posted March 17, 2022 Share Posted March 17, 2022 Where do I find this setting in 8207 I cant seem to find it in the documentation, but I also have trouble finding the right documentation for 8207. Link to comment Share on other sites More sharing options...
Martin Yergeau Posted March 17, 2022 Share Posted March 17, 2022 Here a link for WF doc : WF Doc Then you need to scroll to find the version and type (Client, RS, RC, ) you want Link to comment Share on other sites More sharing options...
David Briars Posted March 17, 2022 Share Posted March 17, 2022 Right click on the adapter icon, select change settings then select the Read/Write Optimization drop down: image.png1879698 126 KB I dont think Ive ever changed this setting. Did you obtain a recommendation/suggestion to change it Has anyone else reset the FETCHSIZE setting and obtained good results Thanks for bring this topic up, Debra. Link to comment Share on other sites More sharing options...
Debra Waybright Posted March 17, 2022 Author Share Posted March 17, 2022 I found a posting of mine from a couple of years ago about it as I was searching for more ideas regarding performance. We are still struggling with our 8207 upgrade. I have a report that runs in less than a minute in 8203 but takes 10 minutes in 8207, hitting the same database. Im just not sure whats going on so Im grasping all the straws. Thanks for finding that. We bumped it to 1000 and it doesnt seem to have made a difference. Link to comment Share on other sites More sharing options...
David Briars Posted March 17, 2022 Share Posted March 17, 2022 Can you trace the SQL generated from the report, when it is run in your two environments, and check to see that it is exactly the same SELECT command Can you check the .mas/.acx being using in each environment to see if exactly the same database instance is being hit Link to comment Share on other sites More sharing options...
Bill Dykema Posted March 17, 2022 Share Posted March 17, 2022 Is it maybe an Active/In Document report Try adding this to a FEX to see if it makes a different: SET ARCOMPRESS=OFF It only does something if ARVERSION is 2 for the report. Link to comment Share on other sites More sharing options...
Debra Waybright Posted March 17, 2022 Author Share Posted March 17, 2022 @DavidBriars You hit it one of the tables is on a different server. Why that impacts it so much more in the new version, Im not sure. Link to comment Share on other sites More sharing options...
David Briars Posted March 17, 2022 Share Posted March 17, 2022 Oh, OK, then maybe someone like your DBA Team can tell you how one or the other database servers are different. Maybe database release Database settings Network traffic to/from one of the db servers faster then the other Catalogue differences, e.g., index created on one instance, and not the other Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now