Where do I find this setting in 8207 I cant seem to find i...

[Debra Waybright]

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.

[Martin Yergeau]

Here a link for WF doc : WF Doc

Then you need to scroll to find the version and type (Client, RS, RC, ) you want

[David Briars]

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.

[Debra Waybright]

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.

[David Briars]

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

[Bill Dykema]

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.

[Debra Waybright]

@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.

[David Briars]

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