How can we handle already existing 20,000 records when we are optimising a new property in production environment.
There are 20,000 already optimised records like name,age,salary etc in prod environment now a requirement came like we need to optimise a new property marital status and include that also along with these records in production,how will we achieve this?
Maantic Inc
IN
Once you optimize it in lower environment, you need to add the database table instance in the product while deploying to prod. That should automatically take care of things in prod.
Cognizant
IN
@SohamM95 so on optimising this new property and passing the db instance how will the old instances be managed automatically?like how the already optimised instances will be handled?
Eclatprime Digital Private Limited
SG
Hi Tanya,
you need to write a custom activity to populate the value to the new column.
other option is you can ignore the existing records and for new records you can create a declare index rule to populate the data.
Last option is you can use DB utility to export the column value from blob column and save it in the column.
Updated: 12 Jun 2024 17:22 EDT
Cognizant
IN
@SohamM95 i found this
https://support.pega.com/discussion/how-optimize-properties-production-environment
but here i have a query like can we run a custom activity in prod?and the first step of this activity is doing obj-browse but obj-browse cant fetch data from blob,so what exactly is this activity going to do?
Tata Consultancy Services
IN
Hi @TanyaS58,
We do have OOTB Activity for re create the indexes for the newly added columns, Just pass the class name then Run.
Activity Name: ReCreateIndexesForClass
Please go though below article it will give you clear idea.
How to optimize properties in production environment
I hope this will help you.
Thanks,
Ashok