The Zurich release has arrived! Interested in new features and functionalities? Click here for more

GlideRecord Update Huge records.. Best Practice

kailashthiyagar
Kilo Guru

Is there a way to do bulk update other than this approach. This script works fine but i feel it might be causing performance issue.. Its one time update only.. But still would like to know what are the other alternative best practices, we have

var macRec=new GlideRecord('x_opt_macro_govern_macros');

  macRec.addQuery('number','!=','');

  macRec.query();

  while(macRec.next()){

  macRec.active='true';

  macRec.update();

  }

1 ACCEPTED SOLUTION
6 REPLIES 6

pradeepksharma



Not able to open the link, will check later and update you...


Thanks for the update. I'm able to open the link. is that not working for you?


pradeepksharma



No.. My company IT policy prevented the link from opening.. Marking your answer as correct