Help for upgrade from 4.11 to 9.0.0

[onepip]

We have being using 4.11 for more than ten years. We have hundreds of stateless statements. Each statement has hundreds of parameterized conditions in where clause.

Just tried upgrading to 9.0.0 and found below problems:

1. startup time(compile and deploy) increase from 140s to 1000s
2. runtime throughput decrease 70 percent.
3. some statement compile fail for int overflow or out of memory in issue In FilterSpecCompilerIndexPlannerWidthWithConditions, int sizeFactorized overflow to be negative. #293

Can you please help understand the gap between 4.11 and 9.0.0 and solve the upgrade problems accordingly?