I have below questions regarding column population which we need to run as part of upgrading our application from Pega 6.2 SP2 to Pega 7.2.2:
1. If complete this task using command line approach, in test evironment we have tested this and for 1497 records its taken 188 seconds out of which 21 seconds is for the actual expose and rest all for the environment initialization, so if we calculate using above 21 second for production which contains round about 1 million record it will take 5 hrs, which is acceptable. But in the log(attached) its saying for around 30000 records approx it will take 1 hr and if we take this then in production this utility will run for 38 hrs which is not acceptable because it will not fit into maintenance window. Please let us know which calculation we should consider or if you any other view or experience on this utility.
2. Can we run the multiple instance of column population either on single server(I don't think this is possible) or multiple server(this is possible as per me). Please let me know your view.
3. If as per question 1, the column population will take around 30-40 hrs, is it more advisable to use the agent to do this task on off business hours as per upgrade guide? One addition question, can we run this agent on business hours also?
4. As per the upgrade guide, this job just expose pxApplication after the upgrade, so just to be doubly sure doesnot it expose any other column also?