I am trying to selectively delete some records from a temporary BPC cube using BADI. As part of this process, I use the standard lite optimize chain for zero elimination after I clear the existing values. The code is working fine but I am facing some performance issues for the same. The temporary cube has approximately 10-20 records at any given time in both the Quality as well as the Production system. The lite optimize chain takes 15 seconds on average in the Quality system and takes close to 120-150 seconds in the Production system to do selective deletion on the temporary BPC cube.
Why is there such a huge difference in the time taken in quality and production even when the number of records in both enviroment are pretty much the same? Any help on analysing this issue would be highly appreciated.