Accelerating the deployments in BCC

Clean up the Publishing DB using following scripts to accelerate deployments in BCC.




DELETE FROM das_deployment;
DELETE FROM das_depl_depldat;
DELETE FROM das_depl_options;
DELETE FROM das_depl_repmaps;
DELETE FROM das_depl_item_ref;
DELETE FROM das_depl_progress;
DELETE FROM das_thread_batch;
DELETE FROM das_deploy_data;
DELETE FROM das_dd_markers;
DELETE FROM das_deploy_mark;
DELETE FROM das_rep_mark;
DELETE FROM das_file_mark;
DELETE FROM das_dep_fail_info;
COMMIT;

3 comments:

  1. How do these delete help? What impact is there to deleting this data? Any precautions to take before deleting (aside from backup of schema), specifically any operations precautions?

    ReplyDelete
  2. Hi Jose,

    Every deployment stores its deployment details(deployment markers) in above mentioned tables. More the number of rows, slower the next inserts would be. So deleting above tables makes deployments quite faster. (Not much as expected). Halting deployments would be only precaution.

    BR,
    Iranna

    ReplyDelete