Designer parameter settings from 3.1 - 4.1

[Former Member]

Hi,

We have universe(s) built in 3.1 that were migrated to 4.1. Queries run fast in 3.1 but very slow in 4.1.

Can any please provide me insight on why this is happening? Is there some setting in Parameters that need to be changed/removed?

We no longer have access to 3.1

Please help!

Thank You

Veena M

[Former Member]

The default values that we are using are :-

Pool Timeout : 10 Min

Array Fetch Size : 250

Array Bind Size : 32767

Login Timeout : 600 sec

[Former Member]

Hi,

I have seen scenario where Array Fetch size value sets to 1 after migrating to 4.1.

Compare this value with 3.1 and check.

If it has changed, set it same as that in 3.1 and then check.

Regards,

Yuvraj